All questions
| Select all |
Very Easy |
|
| Select specific columns I |
Very Easy |
|
| Select specific columns II |
Very Easy |
|
| Select values without a table I |
Easy |
|
| Select values without a table II |
Easy |
|
|
Rename columns I
Premium π |
Very Easy |
|
|
Rename columns II
Premium π |
Very Easy |
|
|
Specify column order I
Premium π |
Very Easy |
|
|
Specify column order II
Premium π |
Very Easy |
| Filter students by name I |
Very Easy |
|
| Filter students by name II |
Very Easy |
|
| Filter students by name III |
Easy |
|
| Filter by age |
Easy |
|
| Count rows which meet a condition I |
Easy |
|
| Show all students with long first names |
Very Easy |
|
| Filter students by year group |
Medium |
|
|
Find all navy products
Premium π |
Easy |
|
|
Count rows which meet a condition II
Premium π |
Easy |
|
|
Filter with a list I
Premium π |
Very Easy |
|
|
Filter with a list II
Premium π |
Easy |
|
| Wildcards I |
Easy |
|
|
Wildcards II
Premium π |
Easy |
|
|
Wildcards III
Premium π |
Easy |
|
|
Combining filters I
Premium π |
Easy |
| Count entries in a table |
Very Easy |
|
| Calculate average age |
Very Easy |
|
| Count unique names |
Very Easy |
|
| Count length of names |
Easy |
|
|
Convert test scores to percentages
Premium π |
Medium |
|
|
Find average age of M users
Premium π |
Easy |
|
|
Calculate profit for each product
Premium π |
Easy |
|
|
Total sales of all products
Premium π |
Very Easy |
|
|
Calculate total orders
Premium π |
Easy |
|
|
Calculate total revenue
Premium π |
Medium |
|
|
Calculate revenue
Premium π |
Easy |
|
|
International book sales
Premium π |
Easy |
|
|
Calculate net hours worked
Premium π |
Very Easy |
|
|
Daily temperature range
Premium π |
Easy |
|
|
Calculate average expense
Premium π |
Easy |
|
|
Employee productivity
Premium π |
Medium |
|
|
Allocate rest days I
Premium π |
Easy |
| Order students by id (ascending) |
Very Easy |
|
| Order students by id (descending) |
Very Easy |
|
|
Order by multiple columns I
Premium π |
Very Easy |
|
|
Order by multiple columns II
Premium π |
Very Easy |
| Find oldest student |
Easy |
|
| Find youngest students |
Easy |
|
|
Find the third youngest student
Premium π |
Easy |
|
|
Find the third most expensive product
Premium π |
Easy |
|
|
Find second youngest user
Premium π |
Easy |
|
|
Find 13th and 14th most expensive produc
Premium π |
Easy |
|
|
Find the 19th cheapest product
Premium π |
Easy |
|
|
First 2 rows
Premium π |
Very Easy |
|
|
First 20 rows
Premium π |
Very Easy |
|
Concatenate names I
Premium π |
Very Easy |
|
|
Concatenate names II
Premium π |
Easy |
|
|
Reverse names
Premium π |
Very Easy |
|
|
Find Gmail users
Premium π |
Easy |
|
|
Find unique year-groups
Premium π |
Easy |
| Count occurrences of each last name |
Easy |
|
| Count students by year group |
Easy |
|
|
Find the second-least popular test
Premium π |
Medium |
|
|
Find duplicate emails
Premium π |
Easy |
|
|
Count users by country
Premium π |
Easy |
|
|
Count orders by status
Premium π |
Easy |
|
|
Average price per product category
Premium π |
Easy |
|
|
Average cost per brand
Premium π |
Easy |
|
|
Count products by department
Premium π |
Easy |
|
|
Count students by class
Premium π |
Easy |
|
|
Count students by class and age
Premium π |
Medium |
|
|
Count products by brand and department
Premium π |
Medium |
|
|
Find min and max prices
Premium π |
Easy |
|
|
Calculate average age per class
Premium π |
Easy |
|
|
Total sales by product
Premium π |
Easy |
|
|
Sum orders by category
Premium π |
Easy |
|
|
Calculate revenue by product category
Premium π |
Medium |
| Show each student's tests |
Easy |
|
| Calculate each student's average test sc |
Easy |
|
| Count the number of tests taken by each |
Easy |
|
| Get name of specific student I |
Medium |
|
|
Count number of Geography tetsts
Premium π |
Easy |
|
| Show all subjects taken by a student |
Medium |
|
|
Find all subjects which have no tests
Premium π |
Medium |
|
|
Find all orders made by a specified user
Premium π |
Medium |
|
|
Count orders by user
Premium π |
Medium |
|
|
Find users without orders
Premium π |
Medium |
|
|
Find all order items for an order
Premium π |
Medium |
|
|
Find each order item's name and price
Premium π |
Hard |
|
|
Find the total value of each order
Premium π |
Hard |
|
|
Calculate profit earned on each order
Premium π |
Hard |
|
|
Select students who took a test
Premium π |
Easy |
| Show the student with the highest score |
Medium |
|
| Rank students by test score |
Medium |
|
|
Calculate average grade per test
Premium π |
Medium |
|
|
Calculate min and max grade per test
Premium π |
Medium |
|
|
Find lagged test scores
Premium π |
Medium |
|
|
Rank products by price
Premium π |
Medium |
|
|
Age vs. average age
Premium π |
Medium |
|
|
Cumulative ages
Premium π |
Medium |
|
|
Average percentage scores
Premium π |
Medium |
|
|
Dense rank students by score
Premium π |
Medium |
|
|
Assign row numbers to tests table
Premium π |
Easy |
|
|
Assign row numbers based on partitions
Premium π |
Medium |
|
|
Cumulative sum of test scores
Premium π |
Medium |
|
|
Calculate moving average number of order
Premium π |
Hard |
|
|
Average price per category window functi
Premium π |
Easy |
|
|
Average cost per brand window function
Premium π |
Easy |
| Show the first student in each yeargroup |
Medium |
|
|
Find all students taking both Geography
Premium π |
Hard |
| Create table I |
Very Easy |
|
| Create table II |
Very Easy |
|
|
Create table III
Premium π |
Easy |
|
|
Create table IV
Premium π |
Easy |
|
|
Create table V
Premium π |
Easy |
|
|
Create table VI
Premium π |
Easy |
|
|
Create table VII
Premium π |
Easy |
|
|
Create table VIII
Premium π |
Easy |
|
|
Create table clone I
Premium π |
Easy |
|
|
Create table clone II
Premium π |
Easy |
|
|
Create table clone III
Premium π |
Easy |
|
|
Create table clone IV
Premium π |
Medium |
|
|
Create table clone V
Premium π |
Medium |
| Alter table I |
Easy |
|
| Alter table II |
Easy |
|
|
Alter table III
Premium π |
Easy |
|
|
Alter table IV
Premium π |
Easy |
|
Show each student's subjects
Premium π |
Hard |
|
|
Show each subject's tests
Premium π |
Medium |
|
|
Put student details into an array
Premium π |
Medium |
|
|
Put order items into an array
Premium π |
Easy |
|
|
Create array of all classes in each year
Premium π |
Medium |
|
|
Find Completed/Processing orders for eac
Premium π |
Hard |
|
Categorise studentsβ ages
Premium π |
Easy |
|
|
Flag users from Brazil and China
Premium π |
Easy |
|
|
Allocate rest days II
Premium π |
Medium |
|
Semi joins I
Premium π |
Easy |
|
|
Semi joins II
Premium π |
Medium |
|
|
Semi joins III
Premium π |
Medium |
|
|
Find orgs with no user visits
Premium π |
Hard |
| Count questions by year |
Medium |
|
| Find most popular questions by year |
Hard |
|
| Find number of (un)answered questions |
Medium |
|
| Month with most unanswered questions |
Medium |
|
| Most active users |
Hard |
|
| Average favourite count |
Medium |
|
| High scoring posts |
Medium |
|
| Rank questions based on views |
Medium |
Get more questions
To access more questions and track your progress, please log in or create an account.