Loading the lesson
Loading the lesson
Search AllRounder.ai
Search the courses, subjects, tracks, games and features, or jump straight to a page.
Search the courses, subjects, tracks, games and features, or jump straight to a page.
5 cards from this section. Quick, good the night before a test.
What SQL function would you use to count the number of users?
Think of how we track the number of entries in a dataset.
How would you aggregate the total sales from a table?
Consider what you're adding up.
What does the AVG function calculate?
Think about how you would find the average score.
True or False: The COUNT function can return 0 if no rows meet the condition.
Consider what happens when there are no results.
Write a complex SQL query that retrieves departments with an average salary above the total average salary and shows the maximum salary within each department.
You'll need to use subqueries to compare average salaries.
Using a sales data table, create a query to find products whose total sales exceed the average sales of all products and list them.
Think about how you would aggregate and compare the totals.
6 more questions in this section. Enroll free to practise them all.
Enroll free