TheDataScientist
pdfEmail required

SQL Interview Pack

40 SQL problems with worked solutions and the reasoning interviewers are listening for.

240 downloads

Contents#

Section Problems
Joins and set operations 8
Aggregation and grouping 7
Window functions 12
Gaps and islands 5
Query reasoning and optimisation 8

Every solution includes the evaluation note — what a strong answer demonstrates beyond producing the right rows.

#Interview prep#Career

Free with your email

Get the SQL Interview Pack

40 problems across joins, window functions, aggregation and gaps-and-islands — each with a solution and a note on what the interviewer is actually assessing.

You also get the weekly build email. One click to unsubscribe, and the download stays yours.

Where this is used

Career Lab

The Analytics Portfolio That Actually Gets Interviews

Three real projects beat thirty notebooks. What hiring managers screen for, and the structure that survives a five-minute skim.

BeginnerDifficulty: Beginner2 min readSQL · Python · Power BI
SQL

Second highest salary per department

Return the second highest salary in each department. If a department has fewer than two distinct salaries, it should not appear. Handle ties…

IntermediateDifficulty: Intermediate8 min