4.1. Identify Top-Selling Products

Try these first

1. 1.

   What SQL command is used to select data from a database?

   Hint

   It's the first keyword in a SQL query.

2. 2.

   How would you limit results to only show 10 items?

   Hint

   This clause comes at the end of your query.

3. 3.

   What is the purpose of the COUNT function in SQL?

   • Count sales
   • Count rows
   • Count products

   Hint

   Think about what you'd want to summarize when querying a database.

4. 4.

   True or False: The ORDER BY clause is optional in a SQL query.

   • True
   • False

   Hint

   Consider if you always want sorted results.

5. 5.

   Given a table with product sales data, write a query to find products that sold more than 100 units, displaying the product ID and the total sold.

   Hint

   You'll need to use COUNT and GROUP BY while filtering the results.

6. 6.

   Create a SQL query to determine how many different products were sold, considering only those with sales data in the last quarter.

   Hint

   Focus on distinct counts and the date range filter.