SELECT month ("Date") "Month" ,"Region","Product Category","Profit","Profit per Item" FROM "Sales" WHERE "Region" = 'West' AND "Profit">500
link= https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=794004000000006022&STANDALONE=true&privatelink=af1696d31521a08719e5035290bc5a43&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true&SEARCHBOX=true&SHOWHIDEOPT=true
This Query Table is valuable as it will see the profitable product categories for this business in The Western region, which can be compared to the other table's profits.
SELECT "Date","Product Category","Product","Customer Name","Sales","Profit" FROM "Sales" WHERE "Region" = 'East' AND "Profit">500
This Query allows for the comparison in profit
link= https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=794004000000006141&STANDALONE=true&privatelink=7f622c31f6faae3b7d57ce2570499d16&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true&SEARCHBOX=true&SHOWHIDEOPT=true
This Query Table allows for the comparison of profitable product categories(+500) from the Eastern region to the Western region of the other table. One can see which area has more, and how much more profitable categories of items to determine where to focus shipping products.
|
Zoho Sheet
Zoho Report
Week 2 Task 4 Spreadsheet
Monday, August 6, 2012
SQL Tables
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment