4. Real-World Use Cases for BAs

Try these first

1. 1.

   What SQL function counts the number of records?

   Hint

   Think about how we can summarize data.

2. 2.

   What does the FROM clause specify in a query?

   Hint

   It describes the source of data.

3. 3.

   What SQL function is used to count records?

   • SUM
   • COUNT
   • AVG

   Hint

   It's for counting entries.

4. 4.

   True or False: The HAVING clause works with raw data.

   • True
   • False

   Hint

   Think about what GROUP BY does.

5. 5.

   You are analyzing user login data for an app. Write a SQL query that could help you understand how many users logged in each month in 2024.

   Hint

   Consider how to extract months and aggregate counts.

6. 6.

   A company's marketing department wants to check which products had zero sales last month. Compose a SQL query that could help them find this information.

   Hint

   Use LEFT JOIN to include all products, checking for those with no sales.