Practice Group By – Aggregate Results (12.2.4) - SQL for QA Analysts

Practise this section

9 questions

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

6 sample questions

Question 1.
What does the GROUP BY clause do?
Show hintHide hint
Think of how you can summarize data.
Question 2.
Write a SQL query to count the number of users registered by email domain.
Show hintHide hint
Look into substring functions for extracting data.
3Question 3.
What does the GROUP BY clause do in SQL?
- It sorts the data in ascending order.
- It combines rows that have the same value in specified columns.
- It retrieves all records from a table.
Show hintHide hint
Think about how we summarize information.
4Question 4.
True or False: GROUP BY can be used with aggregate functions like COUNT and AVG.
- True
- False
Show hintHide hint
Recall our discussion on how to summarize data.
Question 5.
Write a SQL query to find the total revenue generated per product category for the last year.
Show hintHide hint
Make sure your date filters include the correct time frame.
Question 6.
Create a report that shows how many times each user logged in within the last month, grouped by user.
Show hintHide hint
Filter the relevant records before counting.

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