LeetCode SQL

Table of contents

Intro

Recommended Database Problems for You

If you are looking for roles like DA, BA, FA, MA, or BIE with entry-level SQL requirements, you need to complete all the Basic and Intermediate problems listed below.

If you are looking for roles like DS, DE, MLE, or Backend SDE with advanced-level SQL requirements, you need to complete all the problems listed below.

How to Practice on LeetCode?

Some problems require LeetCode Preium Membership, which you can skip for now. LeetCode often offers discounts on Black Friday, and students can claim a discount in the period of back-to-school days.

Validate Your Proficiency

You must pass all Database problems on the first submission. This is critical preparation for a “Whiteboard” style tech interview, where you’ll be coding on Google Docs under high pressure. Without an IDE, you’ll need to be precise with syntax, indentation, and function names.

Pandas on LeetCode

For DS, DE, or MLE, you need to also practice your pandas skill on LeetCode Database. Just click on Code -> Pandas to switch the language.

You don’t have to practice the same difficulty pandas problems as SQL. But at least you need to practice the Basic part.

Before Practice & During Job Hunting

• LeetCode SQL Hack: Cheat code for SQL
• Database Systems: Conver essential database systems for interviews

Database Problems

Basic

• LeetCode SQL Filter
• LeetCode SQL JOIN
• LeetCode SQL GROUP BY
• LeetCode SQL Subquery

Intermediate

• LeetCode SQL Scalar Function
• LeetCode SQL Window Function
• LeetCode SQL RANK
• LeetCode SQL Time Series
• LeetCode SQL Analysis

Advanced

• LeetCode SQL Consecutive Records
• LeetCode SQL Missing Values
• LeetCode SQL Math

Specialized Problems

• LeetCode SQL Swap
• LeetCode SQL DELETE
• LeetCode SQL Pivot Table
• LeetCode SQL Relationships