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.
Write a SELECT statement to get the names of all employees.
Think about which columns you need from the employees table.
Use a WHERE clause to find orders with a status of 'Completed'.
Use the STATUS you see in the orders table.
What does the SELECT statement do?
Think about what SELECT allows you to do with data.
True or False: The LIMIT clause can be used to specify the maximum number of records returned.
Recall the purpose of LIMIT.
Write a complex query using JOIN, COUNT, and GROUP BY to identify the total number of orders each customer has made and sort them in descending order.
Start by figuring out how customers relate to orders.
Consider a dataset with users and their activity logs. Write a query to find which users have more than 10 logins in the last month.
You’ll need to filter by date and aggregate logins.
6 more questions in this section. Enroll free to practise them all.
Enroll free