Future Profit

Tuesday, January 11, 2011

Database II

1. SELECT "Date", "Sales", "Cost", "Profit" FROM "Sales" WHERE "Region"='East'
http://reports.zoho.com/ZDBDataSheetView.cc?OBJID=202103000000005079&STANDALONE=true&privatelink=627a962e9c415aad7a473fe3c656b799&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true

2. SELECT "Date", "Region", "Product Category", "Sales" FROM "Sales" WHERE "Customer Name"='Michael Moore' and "Sales">80
http://reports.zoho.com/ZDBDataSheetView.cc?OBJID=202103000000005177&STANDALONE=true&privatelink=a473b1a83025d190a29a1a344a2c1066&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true

3. SELECT  "Customer Name", "Region", "Product Category", "Sales"
FROM "Sales" WHERE "Product" = 'Fruits and Vegetables'
http://reports.zoho.com/ZDBDataSheetView.cc?OBJID=202103000000005275&STANDALONE=true&privatelink=de5add2804cd36c867fa43d4f4291aba&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true

No comments:

Post a Comment

Hardware and Software

Database