12. SQL for QA Analysts

Try these first

1. 1.

   What does SQL stand for?

   Hint

   Think about what the letters S, Q, and L represent.

2. 2.

   What SQL command is used to retrieve data?

   Hint

   Recall which command allows you to choose specific data.

3. 3.

   What does the SELECT command do in SQL?

   • Insert data
   • Retrieve data
   • Update data

   Hint

   Think about what you want to do with existing data.

4. 4.

   True or False: JOIN is used to combine rows from two tables.

   • True
   • False

   Hint

   Consider why you might need data from more than one table.

5. 5.

   Write a comprehensive SQL query to find all users from a table whose names start with 'A', and sort them by their email addresses.

   Hint

   Remember to use the pattern matching function.

6. 6.

   Explain how you would use SQL to validate that the sum of items in an order matches the total price of that order.

   Hint

   Think about how to retrieve data from both tables effectively.