1. Write an SQL query to show the top 10 best-selling products by total  Qty (i.e., quantity). 

2. Write an SQL query to show the total gross  sales revenues each department makes by selling each brand. 

3. Write an  SQL query to show the total net sales revenues each department makes  in-store and online respectively.  

4. Write an SQL query to show how  many customers are served by all cash registers of Store #1 per hour?  (Note: Store Key should be 1 because only Store #1’s cash registers are  of analytical interest. The fact table records data from each scan. So,  you should not use SUM(Qty) because the question asks the total number  of customers per hour, not the

Answer rating: 100% (QA)

Here are SQL queries for each of the questions Show the top 10 bestselling products by total quantit... View the full answer