SQL Statement

kwajahathydro

Hi All,

I have a question here whereby i am trying to write an sql statement for the following as an example from Nav

1. Table: sales order (Asia Area)
Sales Order Number Customer Date
SO001 Singapore Faire Price 2017.1.14
SO002 China Wu Mei 2017.1.30
SO003 Singapore Giant 2017.3.8

2. Table: sales order Detail (Asia Area)
Sales Order Number Item Name Unit Price Quantity
SO001 TV 30” 1000 30
SO001 TV 35” 1200 20
SO002 AirCon 200 700 80
SO002 Washing Machine 300 900 50
SO003 TV 30” 950 60
SO003 AirCon 200 800 100

3. Table: Item (Singapore Item Master)
Item Name Description UoM
TV 30” Television 30” Set
TV 35” Television 35” Set
AirCon 200 Air Conditioner 200 PC
AirCon 500 Air Conditioner 500 PC
Oven 5KW Home Oven 5KW PC

how to write SQL statement (like, Select … From …) to export sales amount of Singapore items by monthly in 2017 Q1, and sorting by month and then amount, which includes zero amount item. And provide the result of your SQL statement.

Regards
khan