12.2.1. SELECT – Retrieve Data

Try these first

1. 1.

   What key SQL statement would you use to retrieve all columns from the 'products' table?

   Hint

   Use the SELECT command to pull all columns.

2. 2.

   Write a SQL query to fetch user names from the 'users' table.

   Hint

   Focus on specifying the column you want to retrieve.

3. 3.

   What is the purpose of the SELECT statement in SQL?

   • To modify records
   • To delete data
   • To retrieve data

   Hint

   Think about what SQL commands are meant for data retrieval.

4. 4.

   True or False: The WHERE clause can be used to filter records based on conditions.

   • True
   • False

   Hint

   Remember the role of WHERE in narrowing down SQL query results.

5. 5.

   Write a SQL query that retrieves the top 5 users who have made the most orders, along with their total order amounts.

   Hint

   Consider using COUNT and SUM functions along with GROUP BY for totals.

6. 6.

   Construct a query that finds the average order value for all orders received in 2022, grouped by each month.

   Hint

   Utilize the AVG function to calculate average values while filtering by year.