Skip to content
SQLSimplified

medium Problems

41 problems to solve.

medium
Actors and Their Primary Movie
Dataset: movies
medium
Authors With Multiple Books
Dataset: library
medium
Average Grade Per Course
Dataset: school
medium
Average Critic Rating
Dataset: movies
medium
Average Order Value
Dataset: store
medium
Average Quantity Per Order
Dataset: store
medium
Average Salary by Department
Dataset: employees
medium
Average Score Per Course
Dataset: school
medium
Books by Authors From Japan
Dataset: library
medium
Books Per Author
Dataset: library
medium
Books With Author Name
Dataset: library
medium
Revenue by Customer City
Dataset: store
medium
Customer Total Spend
Dataset: store
medium
Customers With No Completed Orders
Dataset: store
medium
Customers With Multiple Orders
Dataset: store
medium
Headcount by Department Location
Dataset: employees
medium
Top Paying Department
Dataset: employees
medium
Employee Salary Quartiles
Dataset: employees
medium
Employee vs Department Average
Dataset: employees
medium
Employees Above Dept Average
Dataset: employees
medium
Employees Hired After 2020
Dataset: employees
medium
Employee Salary Bands
Dataset: employees
medium
Employees Whose Name Starts With M
Dataset: employees
medium
Employees With Department Name
Dataset: employees
medium
Average Budget by Genre
Dataset: movies
medium
Highest Rated Movie Per Genre
Dataset: movies
medium
Managers and Their Reports
Dataset: employees
medium
Movie Count by Decade
Dataset: movies
medium
Movies Above Genre Average Budget
Dataset: movies
medium
Comedy Movies 2016-2020
Dataset: movies
medium
Movies Per Director
Dataset: movies
medium
Order Status Breakdown
Dataset: store
medium
Orders Per Customer
Dataset: store
medium
Products Never Ordered
Dataset: store
medium
Revenue by Category
Dataset: store
medium
Salary Bands
Dataset: employees
medium
Average Student Score
Dataset: school
medium
Passing Students Count
Dataset: school
medium
Top 3 Salaries Per Department
Dataset: employees
medium
Top Selling Products
Dataset: store
medium
Total Books by Publisher
Dataset: library