1.1. Select Statement

Try these first

1. 1.

   Write a SQL query to select all columns from the 'employees' table.

   Hint

   Use SELECT and FROM clauses.

2. 2.

   How would you filter to find orders with 'Shipped' status?

   Hint

   Think about the WHERE clause.

3. 3.

   What SQL clause would you use to filter results?

   • SELECT
   • WHERE
   • ORDER BY
   • LIMIT

   Hint

   Think about the purpose of each clause.

4. 4.

   True or False: The ORDER BY clause can sort results in either ascending or descending order.

   • True
   • False

   Hint

   Consider how you can use ORDER BY in SQL.

5. 5.

   You need to analyze user behavior by collecting login data for the past month. Write a SQL query that retrieves user IDs and counts their logins for that month, limited to users with more than 5 logins.

   Hint

   Focus on filtering the date and counting occurrences.

6. 6.

   You are tasked with finding the top 5 customers who have spent the most over the last year. Create the SQL query to retrieve each customer's ID and total spent amount.

   Hint

   Remember to sum the amounts and sort top to bottom.