SQL Technical Interviews

Guide for SQL technical interviews and how to prepare.

This resource is crafted to aid anyone in refining their SQL expertise, specifically designed for those preparing for technical interviews. I've organized the content by categorizing topics drawn from prominent problem-solving websites like LeetCode, HackerRank, and others.

Topics

You should have the following prerequisites (SELECT, ORDER BY, WHERE, GROUP BY, Regex, CASE WHEN, IF, WHILE, JOINs)

SELECTing

Here you'll learn how to use SELECT Statements with ORDER BY and WHERE etc

Problem	Done
Revising the Select Query	✅
Revising the Select Query 2	✅
Select All SQL	✅
Select by ID	✅
Japanese Cities Attributes	✅
Japanese Cities Name	✅
Weather Observation Station 1	✅
Weather Observation Station 2	✅
Weather Observation Station 3	✅
Weather Observation Station 4	✅
Weather Observation Station 5	✅
Weather Observation Station 6	✅
Weather Observation Station 7	✅
Weather Observation Station 8	✅
Weather Observation Station 9	✅

LeetCode Problems

Problem	Done
Big Countries	✅
Recyclable and Low Fat Products	✅
Find Customer Referee	✅
Customers Who Never Order	✅

CASE WHEN

Problem	Done
Calculate Special Bonus	✅
Swap Salary	✅
Delete Duplicate Emails	✅

JOINS