Question: Using sql commands show what product has low sale amount (8,000) 2. what product has the highest Total Product Price? Total product price is the

Using sql commands
show what product has low sale amount (8,000) 2. what product has the highest Total Product Price? Total product price is the sum of sales amount, tax amount, and freight amount 3., show total number of orders by city and state.
FactinternetSalesReason SalesOrderNumber SalesOrderLine Number SalesReasonkey DimDate Datekey FullDate Alternat. DimSalesTerritory Sales TerritoryKey Sales Territory Alternate. Sales Territory Region Sales Territory Country Sales Territory Group Sales Territoryimage DayNumberOfw. English DayName. DimGeography -od GeographyKey City StateProvinceCode SpanishDayNam... French DayName FactinternetSales ProductKey Order DateKey DueDatekey Ship Datkey Customerkey StateProvinceName DayNumberOfM. DayNumber Of Year WeekNumberOfy. DimCustomer CustomerKey Geography Key Customer Alterna Country Region English Country Re. Spanish Country French Country Re... Dim Promotion Title Promotionkey AR Promotion key Currencykey Sales Territory Key SalesOrder Number SaleOrderinumber First Name Promotion Altern.. Middle Name English Promotion Spanish Promotio French Promotion Discount Pet English Promotio Spanish Promotio French Promotion English Promotio. Dim Product ProductKey Product Alternate DimProductSubcatego ProductSubcateg. A ProductSubcateg English Products Spanish Products DimCurrency Currencykey Currency Alternatekey Currency Name Dim ProductCategory Product Category Key Product Category Altern... English Product Categor... Spanish Product Catego... French Product Categor. ProductSubcateg- Weight Unit Mess.. SizeUnit Messure French Products English Product Spanish Product French ProductNL Standard Cost Finished GoodsFlag FactinternetSalesReason SalesOrderNumber SalesOrderLine Number SalesReasonkey DimDate Datekey FullDate Alternat. DimSalesTerritory Sales TerritoryKey Sales Territory Alternate. Sales Territory Region Sales Territory Country Sales Territory Group Sales Territoryimage DayNumberOfw. English DayName. DimGeography -od GeographyKey City StateProvinceCode SpanishDayNam... French DayName FactinternetSales ProductKey Order DateKey DueDatekey Ship Datkey Customerkey StateProvinceName DayNumberOfM. DayNumber Of Year WeekNumberOfy. DimCustomer CustomerKey Geography Key Customer Alterna Country Region English Country Re. Spanish Country French Country Re... Dim Promotion Title Promotionkey AR Promotion key Currencykey Sales Territory Key SalesOrder Number SaleOrderinumber First Name Promotion Altern.. Middle Name English Promotion Spanish Promotio French Promotion Discount Pet English Promotio Spanish Promotio French Promotion English Promotio. Dim Product ProductKey Product Alternate DimProductSubcatego ProductSubcateg. A ProductSubcateg English Products Spanish Products DimCurrency Currencykey Currency Alternatekey Currency Name Dim ProductCategory Product Category Key Product Category Altern... English Product Categor... Spanish Product Catego... French Product Categor. ProductSubcateg- Weight Unit Mess.. SizeUnit Messure French Products English Product Spanish Product French ProductNL Standard Cost Finished GoodsFlag
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
