Skip to content

DoniaEid/SQL_problem_solving

Repository files navigation

🚀 LeetCode SQL 50 Solutions

My solutions to the LeetCode SQL 50 Study Plan using MySQL.


📖 About

This repository contains my solutions to the LeetCode SQL 50 Study Plan.

The purpose of this repository is to:

  • 💡 Improve SQL problem-solving skills.
  • 🛢️ Practice MySQL queries.
  • 📚 Prepare for coding interviews.
  • 🎯 Build a strong SQL reference.

📂 Topics

📌 Basic Select

  • Recyclable and Low Fat Products
  • Find Customer Referee
  • Big Countries
  • Article Views I
  • Invalid Tweets

🔗 Basic Joins

  • Replace Employee ID With The Unique Identifier
  • Product Sales Analysis I
  • Customer Who Visited but Did Not Make Any Transactions
  • Rising Temperature
  • Average Time of Process per Machine
  • Employee Bonus
  • Students and Examinations
  • Managers with at Least 5 Direct Reports
  • Confirmation Rate

📊 Basic Aggregate Functions

  • Not Boring Movies
  • Average Selling Price
  • Project Employees I
  • Percentage of Users Attended a Contest
  • Queries Quality and Percentage
  • Monthly Transactions I
  • Immediate Food Delivery II
  • Game Play Analysis IV

📈 Sorting and Grouping

  • Number of Unique Subjects Taught by Each Teacher
  • User Activity for the Past 30 Days I
  • Product Sales Analysis III
  • Classes With at Least 5 Students
  • Find Followers Count
  • Biggest Single Number
  • Customers Who Bought All Products

⚡ Advanced Select and Joins

  • The Number of Employees Which Report to Each Employee
  • Primary Department for Each Employee
  • Triangle Judgement
  • Consecutive Numbers
  • Product Price at a Given Date
  • Last Person to Fit in the Bus
  • Count Salary Categories

🔍 Subqueries

  • Employees Whose Manager Left the Company
  • Exchange Seats
  • Movie Rating
  • Restaurant Growth
  • Friend Requests II: Who Has the Most Friends
  • Investments in 2016
  • Department Top Three Salaries

📝 Advanced String Functions

  • Fix Names in a Table
  • Patients With a Condition
  • Delete Duplicate Emails
  • Second Highest Salary
  • Group Sold Products By The Date
  • List the Products Ordered in a Period
  • Find Users With Valid E-Mails

🏆 Progress

Status Progress
✅ Solved Problems 50 / 50
🏅 Badge LeetCode SQL 50
💻 Language MySQL

🛠️ Technologies

  • SQL
  • MySQL
  • LeetCode

🎯 Repository Goal

This repository is created to:

  • 📚 Practice SQL.
  • 💼 Prepare for technical interviews.
  • 🚀 Track my progress.
  • 💡 Help others learn SQL.

🌟 Thanks for visiting!

If you found this repository helpful or inspiring, consider giving it a ⭐.

It motivates me to keep learning and sharing more solutions.

👩‍💻 Connect with Me

💛 LeetCode: https://leetcode.com/u/DoniaEid/


LeetCode Topics

Database

0175-combine-two-tables

About

No description or website provided.

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

No releases published

Packages

 
 
 

Contributors