Practice Aggregations & Grouping (3) - SQL for Business Analysts

Practise this section

10 questions

Flashcard drill
5 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
4 questions · about 3 min · pass mark 70%. Hints available.
Sign up to start the quiz

6 sample questions

Question 1.
What function would you use to count the total number of records?
Show hintHide hint
Remember, it gives you the headcount of records.
Question 2.
What does the SUM function calculate?
Show hintHide hint
Think about adding up numbers.
3Question 3.
What function would you use to find the total number of sales transactions?
- COUNT
- SUM
- AVG
Show hintHide hint
It’s used for headcounts.
4Question 4.
The HAVING clause is used to filter records before grouping.
- True
- False
Show hintHide hint
Associated with GROUP BY.
Question 5.
How would you find out which products sold the most in the last month? Provide a SQL query example.
Show hintHide hint
Filter sales based on dates and group by product_id.
Question 6.
Draft a SQL query using a GROUP BY and HAVING clause to find out how many support tickets are open for each priority level, and show only those levels with more than 5 tickets.
Show hintHide hint
Ensure to count and set a threshold for open tickets.

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