Skip to content

shivamsan/LeetCode-SQL-50

Repository files navigation


SQL-50 Challenge πŸš€

Welcome to my SQL-50 Challenge repository! πŸŽ‰

This repository is dedicated to my journey of solving the Top 50 SQL Questions from the LeetCode SQL-50 Challenge. The goal is to enhance my SQL skills, stay consistent, and document my progress.

πŸ† Challenge Details

  • Platform: LeetCode
  • Study Plan: Top SQL 50
  • Duration: 50 days
  • Frequency: 1 question per day

πŸ“‚ Repository Structure

The repository is structured as follows:

.
β”œβ”€β”€ README.md
β”œβ”€β”€ Day_1
β”‚   β”œβ”€β”€ problem.md
β”‚   └── solution.sql
β”œβ”€β”€ Day_2
β”‚   β”œβ”€β”€ problem.md
β”‚   └── solution.sql
...
β”œβ”€β”€ Day_50
    β”œβ”€β”€ problem.md
    └── solution.sql

  • Each day's folder contains:
    • problem.md: πŸ“œ The problem statement from LeetCode.
    • solution.sql: πŸ’Ύ My SQL solution to the problem.

πŸš€ How It Works

  1. I pick one SQL question from the study plan every day.
  2. Solve the question and document the solution in this repository.
  3. Upload the solution with a brief explanation (if needed).

πŸ”— Links


πŸ“ˆ Progress

Day Problem Title Solution Link
1 Recyclable and Low Fat Products Solution
2 Find Customer Referee Solution
3 Big Countries Solution

🎯 Goals

  • Strengthen SQL Concepts: Gain a solid understanding of SQL queries, joins, aggregations, and more.
  • Consistency: Develop a habit of daily problem-solving.
  • Share Knowledge: Maintain a clean and informative repository for others to learn from.

Feel free to explore my solutions and contribute if you find ways to improve them. Let's ace SQL together! πŸ’ͺ


πŸ’‘ Running the Solutions

  1. Copy the content of the solution.sql file for the respective day.
  2. Open your SQL database management tool.
  3. Execute the query to see the results.

πŸ“¬ Contact

For any questions or suggestions, feel free to reach out to me via GitHub issues. Happy coding! πŸŽ‰


πŸ“¬ Feedback

If you have any suggestions or feedback, don't hesitate to reach out.

Happy coding! 😊


About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published