What was total sales in January 2009? USING SQL ANSWER SHOULD BE IN WHOLE NUMBER. In this assignment, you will demonstra
Posted: Mon Jun 06, 2022 6:49 am
What was total sales in January 2009? USING SQL
ANSWER SHOULD BE IN WHOLE NUMBER.
In this assignment, you will demonstrate what you learned about writing advanced SQL queries to a sample database.
NOTE: The result of the query should be the answer.
For example, if the question states How many products have a 'Mid' Stock Type Name. The query need to be written as
select count(*)
from DimProduct
where StockTypeName = 'Mid'
This returns the number 763
ANSWER SHOULD BE IN WHOLE NUMBER.
In this assignment, you will demonstrate what you learned about writing advanced SQL queries to a sample database.
NOTE: The result of the query should be the answer.
For example, if the question states How many products have a 'Mid' Stock Type Name. The query need to be written as
select count(*)
from DimProduct
where StockTypeName = 'Mid'
This returns the number 763