Practice Real-world Use Cases For Bas (4) - SQL for Business Analysts

Practise this section

8 questions

Flashcard drill
4 cards from this section. Quick, good the night before a test.
Exercise
6 questions · about 4 min · pass mark 70%. Hints available.
Sign up to start the exercise
Quiz
2 questions · about 1 min · pass mark 70%. Hints available.
Sign up to start the quiz

6 sample questions

Question 1.
What SQL function counts the number of records?
Show hintHide hint
Think about how we can summarize data.
Question 2.
What does the FROM clause specify in a query?
Show hintHide hint
It describes the source of data.
3Question 3.
What SQL function is used to count records?
- SUM
- COUNT
- AVG
Show hintHide hint
It's for counting entries.
4Question 4.
True or False: The HAVING clause works with raw data.
- True
- False
Show hintHide hint
Think about what GROUP BY does.
Question 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.
Show hintHide hint
Consider how to extract months and aggregate counts.
Question 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.
Show hintHide hint
Use LEFT JOIN to include all products, checking for those with no sales.

4 more questions in this section. Enroll free to practise them all.