12.2. Basic SQL Queries for QA

Try these first

1. 1.

   What command would you use to fetch all user records?

   Hint

   Think about the way we retrieve data.

2. 2.

   How do you filter users with email domain '@example.com'?

   Hint

   Use the LIKE operator for pattern matching.

3. 3.

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

   • UPDATE
   • SELECT
   • DELETE

   Hint

   It's the command you use to fetch data.

4. 4.

   The WHERE clause is used for filtering results: True or False?

   • True
   • False

   Hint

   Consider its purpose in a SQL statement.

5. 5.

   Write a query that lists all users who have more than one order and include the total number of orders for each user.

   Hint

   You will need both GROUP BY and HAVING to filter after aggregation.

6. 6.

   Create a complex query that retrieves user names who registered in the last month along with their order totals.

   Hint

   You will combine JOIN, WHERE, and GROUP BY.