5. Summary Table

Try these first

1. 1.

   What SQL command would you use to select all columns from the 'products' table?

   Hint

   Remember, `*` means all columns.

2. 2.

   How would you filter orders that are pending?

   Hint

   Think about adding a WHERE clause.

3. 3.

   What SQL command retrieves data from a table?

   • UPDATE
   • SELECT
   • DELETE

   Hint

   Think about the purpose of the command.

4. 4.

   True or False: The WHERE clause is used to filter results.

   • True
   • False

   Hint

   Recall what WHERE does in a query.

5. 5.

   Write a query that retrieves the total number of orders and groups them by customer ID, then filter so only customers with more than 2 orders are shown.

   Hint

   Combine COUNT with GROUP BY and HAVING.

6. 6.

   Construct a SQL statement to find product IDs and their associated sales, including those with zero sales using appropriate joins.

   Hint

   Use a LEFT JOIN to include all products.