SQL Queries

SELECT "Customer Name", "Region", "Product Category", "Profit" FROM "Sales" WHERE "Region"='East' This allows for a company to see what category of product created the most profit while conducting business in the East region. https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=793504000000020016&STANDALONE=true&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true&SEARCHBOX=true&SHOWHIDEOPT=true SELECT "Date", "Product", "Region", "Cost" FROM "Sales" WHERE "Region"='East' AND "Cost">10.00 This allows for a company to see what products in the East region are costing them the most in money. I made it so that only products costing them over 10 dollars were listed. https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=793504000000020105&STANDALONE=true&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true&SEARCHBOX=true&SHOWHIDEOPT=true