This repository contains solutions and explanations for the SQL 50 challenge on LeetCode, designed to enhance SQL skills by covering a variety of core and advanced concepts.
The SQL 50 collection on LeetCode provides a diverse set of SQL problems ranging from easy to hard. These exercises are ideal for anyone looking to strengthen their SQL knowledge and prepare for technical interviews or real-world data tasks.
- Basic Queries – Select statements and filtering
- Joins – Inner, Left, Right, and Full joins
- Aggregate Functions –
SUM(),COUNT(),AVG(), etc. - Sorting and Grouping –
ORDER BY,GROUP BY, andHAVING - Subqueries – Correlated and non-correlated subqueries
- Window Functions –
RANK(),ROW_NUMBER(),PARTITION BY - String Functions and Regex – Text manipulation and pattern matching
Happy Coding! 🎉