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.
4 cards from this section. Quick, good the night before a test.
What does INNER JOIN do in SQL?
Think about how you combine data across related tables.
Define an aggregate function.
Consider what you might want to find the total or average of.
What type of join returns all matching records?
Think about the relationship enforced by the join.
True or False: LEFT JOIN returns only matching rows.
Visualize the data returned in both tables.
Create a SQL query using an aggregate function to find how many users have made orders in total.
Think about how you can count unique entries.
Write a SQL query that retrieves users who have not made any orders, using a subquery.
Consider how to filter non-participating users based on another table.
6 more questions in this section. Enroll free to practise them all.
Enroll free