Skip to content

My solutions to the LeetCode SQL 50 study plan with SQL queries, problem explanations, and runtime screenshots.

Notifications You must be signed in to change notification settings

Harsh-Belekar/LeetCode-SQL-50

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

13 Commits
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

🧩 LeetCode SQL 50 – My SQL Solutions

This repository contains my solutions to the LeetCode SQL 50 study plan.
Each problem has its own folder containing:

  • solution.sql β€” SQL query

  • README.md β€” problem description, examples, and explanation

  • runtime.png β€” screenshot of my submission runtime on LeetCode


πŸ“‚ Repository Structure

LeetCode-SQL-50/
β”‚
β”œβ”€β”€ 01-Recyclable-and-Low-Fat-Products/
β”‚   β”œβ”€β”€ solution.sql
β”‚   β”œβ”€β”€ runtime.png
β”‚   └── README.md
β”‚
β”œβ”€β”€ 02-Find-Customer-Referee/
β”‚   β”œβ”€β”€ solution.sql
β”‚   β”œβ”€β”€ runtime.png
β”‚   └── README.md
β”‚
β”œβ”€β”€ 03-Big-Countries/
β”‚   β”œβ”€β”€ solution.sql
β”‚   β”œβ”€β”€ runtime.png
β”‚   └── README.md
β”‚
β”‚   ... (continues for all 50 problems)
β”‚
└── README.md


🧠 Topics Covered

  • Basic SQL
  • SELECT, WHERE
  • ORDER BY, DISTINCT
  • Aggregate Functions (COUNT, SUM, AVG)
  • GROUP BY & HAVING
  • JOIN (INNER, LEFT, RIGHT)
  • UNION & Subqueries
  • Window Functions
  • Ranking Functions (RANK, DENSE_RANK, ROW_NUMBER)
  • Advanced SQL Pattern

🎯 Goal

To strengthen SQL query writing, database problem-solving skills, and improve preparation for data-related roles by solving all 50 problems from the LeetCode SQL Study Plan.


πŸ”— Reference

πŸ“˜ LeetCode Study Plan: Top SQL 50 (https://leetcode.com/studyplan/top-sql-50/)

About

My solutions to the LeetCode SQL 50 study plan with SQL queries, problem explanations, and runtime screenshots.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published