Use the Software Depot database to prepare data to make 3 quries Level 1 Query oA query
Question:
Use the Software Depot database to prepare data to make 3 quries
Level 1 Query
oA query that contains the product title, level, price, and quantity sold.
o Include only Level 1 products.
o In a new field, define an expression that calculates the total sales (price x quantity sold) for each product.
o Give the calculated field an appropriate name.
o In order for the results to display correctly, you will need to turn on the Totals row (sigma tool under Query Design). Leave all items in the Totals row to set to "Group By"
o Save this query as "Level 1 Sales".
Level 2 Query
o A query that contains the product title, level, price, and quantity sold.
o Include only Level 2 products.
o In a new field, define an expression that calculates the total sales (price x quantity sold) for each product.
o Give the calculated field an appropriate name.
o In order for the results to display correctly, you will need to turn on the Totals row (sigma tool under Query Design). Leave all items in the Totals row to set to "Group By"
o Save this query as "Level 2 Sales".
Level 3 Query
o Aquery that contains the product title, level, price, and quantity sold.
o Include only Level 3 products.
o In a new field, define an expression that calculates the total sales (price x quantity sold) for each product.
o Give the calculated field an appropriate name.
o In order for the results to display correctly, you will need to turn on the Totals row (sigma tool under Query Design). Leave all items in the Totals row to set to "Group By"
o Save this query as "Level 3 Sales".