1. Basic SQL Queries

Try these first

1. 1.

   Write a SELECT statement to get the names of all employees.

   Hint

   Think about which columns you need from the employees table.

2. 2.

   Use a WHERE clause to find orders with a status of 'Completed'.

   Hint

   Use the STATUS you see in the orders table.

3. 3.

   What does the SELECT statement do?

   • It deletes records from a table.
   • It retrieves data from one or more tables.
   • It modifies data in a table.

   Hint

   Think about what SELECT allows you to do with data.

4. 4.

   True or False: The LIMIT clause can be used to specify the maximum number of records returned.

   • True
   • False

   Hint

   Recall the purpose of LIMIT.

5. 5.

   Write a complex query using JOIN, COUNT, and GROUP BY to identify the total number of orders each customer has made and sort them in descending order.

   Hint

   Start by figuring out how customers relate to orders.

6. 6.

   Consider a dataset with users and their activity logs. Write a query to find which users have more than 10 logins in the last month.

   Hint

   You’ll need to filter by date and aggregate logins.