Top 50 Interview Questions

Ace your SQL Interviews.

Practice the 50 most frequently asked SQL interview questions. Each challenge includes an interactive environment to test your queries against realistic schemas.

Your Progress

0 of 50 challenges completed

0%

Start Practicing

Challenge List

Explore all 50 challenges across 7 topics.

T1 Select

Basic querying and filtering operations.

Recyclable and Low Fat Products

Find Customer Referee

Article Views I

T2 Basic Joins

Combining data across multiple tables.

Replace Employee ID With The Unique Identifier

Product Sales Analysis I

Customer Who Visited but Did Not Make Any Transactions

Rising Temperature

Average Time of Process per Machine

Students and Examinations

Managers with at Least 5 Direct Reports

Confirmation Rate

T3 Basic Aggregate Functions

Aggregating and summarizing data.

Not Boring Movies

Average Selling Price

Project Employees I

Percentage of Users Attended a Contest

Queries Quality and Percentage

Monthly Transactions I

Immediate Food Delivery II

Game Play Analysis IV

T4 Sorting and Grouping

Ordering results and complex grouping.

Number of Unique Subjects Taught by Each Teacher

User Activity for the Past 30 Days I

Product Sales Analysis III

Classes More Than 5 Students

Find Followers Count

Biggest Single Number

Customers Who Bought All Products

T5 Advanced Select and Joins

Complex relationships and filtering patterns.

The Number of Employees Which Report to Each Employee

Primary Department for Each Employee

Triangle Judgement

Consecutive Numbers

Product Price at a Given Date

Last Person to Fit in the Bus

Count Salary Categories

T6 Subqueries

Writing nested and modular queries.

Employees Whose Manager Left the Company

Restaurant Growth

Friend Requests II: Who Has the Most Friends

Investments in 2016

Department Top Three Salaries

T7 Advanced String Functions / Regex / Clause

String manipulation and advanced clauses.

Fix Names in a Table

Patients With a Condition

Delete Duplicate Emails

Second Highest Salary

Group Sold Products By The Date

List the Products Ordered in a Period

Find Users With Valid E-Mails