Skip to content

RuttalaRenuka/LeetCode-SQL-30-days

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

70 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Got it! Here's a cleaner version of your README.md with only Day 1 filled in and other days marked as "To be updated". This avoids broken links and gives you space to update daily.


30 Days of SQL – LeetCode Challenge

Welcome to my journey of solving SQL problems on LeetCode for 30 days!

🔄 Ongoing challenge – I will update this every day!


📅 Daily Progress

Day Topic/Category Problem Name LeetCode Link
Day 1 Join Basics Combine Two tables Link
Day 2 join basics highest salary https://leetcode.com/problems/employees-earning-more-than-their-managers/ /
Day 3 groupby duplicate rows https://leetcode.com/problems/duplicate-emails/description/
Day 4 In operator customers who have not order https://leetcode.com/problems/customers-who-never-order/description/
Day 5 merge merging tables https://leetcode.com/problems/triangle-judgement/
Day 6 group by having more matched actors https://leetcode.com/problems/actors-and-directors-who-cooperated-at-least-three-times/
Day 7 basic sql Game play analysis https://leetcode.com/problems/game-play-analysis-i/description/
Day 8 joins employeesbonus https://leetcode.com/problems/employee-bonus/description/
Day 9 having class with least students https://leetcode.com/problems/classes-with-at-least-5-students/
Day 10 Human traffic stadiun using group ,order https://leetcode.com/problems/human-traffic-of-stadium/description/
Day 11 orders joins and groping https://leetcode.com/problems/list-the-products-ordered-in-a-period/description/
Day 12 percentage arthimetic https://leetcode.com/problems/percentage-of-users-attended-a-contest/description/
Day 13 subquery Biggest single number https://leetcode.com/problems/biggest-single-number/description/
Day 14 joins project employess https://leetcode.com/problems/project-employees-i/description/
Day 15 joins product sales https://leetcode.com/problems/product-sales-analysis-i/
Day 16 group by number of unique subjects https://leetcode.com/problems/number-of-unique-subjects-taught-by-each-teacher/description/
Day 17 Regexp valid email check ✅ https://leetcode.com/problems/find-valid-emails/
Day 18 cases months problem https://leetcode.com/problems/reformat-department-table/description/
Day 19 group by group sold products https://leetcode.com/problems/group-sold-products-by-the-date/description/
Day 20 subquery finding students who improved https://leetcode.com/problems/find-students-who-improved/description/
Day 21 joins , group by student sibjects https://leetcode.com/problems/students-and-examinations/description/
Day 22 round function subscription analyses https://leetcode.com/problems/analyze-subscription-conversion/description/
Day 23 joins find books with no null values https://leetcode.com/problems/find-books-with-no-available-copies/description/
Day 24 group customers who bought all products https://leetcode.com/problems/customers-who-bought-all-products/description/
Day 25 all cluases last person to fit in bu https://leetcode.com/problems/last-person-to-fit-in-the-bus/description/
Day 26 functions product sales 111 https://leetcode.com/problems/product-sales-analysis-iii/description/
Day 27 transactions monthly transactions
Day 28 case capital gainloss https://leetcode.com/problems/capital-gainloss/description/
Day 29 joins average selling price https://leetcode.com/problems/average-selling-price/solutions/
Day 30 all combinations user activity for past 30 days https://leetcode.com/problems/user-activity-for-the-past-30-days-i/description/

🛠 How to Use

Each day's solution is stored in a file named:

  • Day01.sql
  • Day02.sql
  • ...

🔗 Resources


About

MY solutions for the 30-Day LeetCode SQL challenge

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors