12.2.2. WHERE – Filter Results

Try these first

1. 1.

   Write a SQL query to fetch all orders with status 'completed'.

   Hint

   Use 'completed' as your condition in the WHERE clause.

2. 2.

   How can you retrieve users who registered after January 1, 2022?

   Hint

   Think about comparing the registration date.

3. 3.

   What SQL clause is used to filter records based on conditions?

   • JOIN
   • WHERE
   • SELECT

   Hint

   Remember the keyword that starts with 'W' for filtering.

4. 4.

   True or False: The WHERE clause can be used to select only specific columns.

   • True
   • False

   Hint

   Think about what the SELECT statement does.

5. 5.

   Write a complex query to find users who registered in 2021 and have made more than 3 orders.

   Hint

   Combine filtering dates and subquery for order counts.

6. 6.

   Construct a query that finds all products with a name containing 'wire' and a price above 30.

   Hint

   Use the LIKE operator for pattern matching.