❓

Question of the Week

Market Basket Pairs

Hard 75Self JOIN + COUNT

Find pairs of products most frequently purchased together in the same order.

Solve

Questions

Question TitleCompleted
Select All Employees
EasySELECT
Count Total Orders
EasyCOUNT
Find Sales Department Staff
EasyWHERE
Most Expensive Product
EasyORDER BY + LIMIT
Distinct Job Titles
EasyDISTINCT
Orders Placed in 2023
EasyDate Filter
Total Revenue
EasySUM
Customers Alphabetically
EasyORDER BY
Products Under $50
EasyWHERE
Active vs Inactive Users
EasyGROUP BY
Average Product Price
EasyAVG
Employees with No Manager
EasyIS NULL
Headcount Per Department
EasyGROUP BY + COUNT
Orders Within a Date Range
EasyBETWEEN
Products Matching a Pattern
EasyLIKE
Customers by City
EasyWHERE + ORDER BY
Employees Earning Above Average
EasyScalar Subquery
Order Count Per Customer
EasyGROUP BY + COUNT
Most Recent Order Per Customer
EasyMAX + GROUP BY
Low Stock Products
EasyWHERE + ORDER BY

1–20 of 120 questions