Skip to content

Sahil-Shimpi/SQL-Problem-Solving

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

56 Commits
01. Marvel Cities.sql
01. Marvel Cities.sql
 
 
02. Spotify Sessions.sql
02. Spotify Sessions.sql
 
 
03. Students DB.sql
03. Students DB.sql
 
 
04. Sales Executive.sql
04. Sales Executive.sql
 
 
05. IMDb Metacritic Rating.sql
05. IMDb Metacritic Rating.sql
 
 
06. Director's Actor.sql
06. Director's Actor.sql
 
 
07. Duplicate Emails.sql
07. Duplicate Emails.sql
 
 
08. Big Countries.sql
08. Big Countries.sql
 
 
09. Second Highest Salary.sql
09. Second Highest Salary.sql
 
 
10. Combine Two Tables.sql
10. Combine Two Tables.sql
 
 
11. IMDb Rating.sql
11. IMDb Rating.sql
 
 
12. Classes with more than 5 students.sql
12. Classes with more than 5 students.sql
 
 
13. Shortest Distance.sql
13. Shortest Distance.sql
 
 
14. Customer Placing the Largest Number Orders.sql
14. Customer Placing the Largest Number Orders.sql
 
 
15. Customers Who Never Order.sql
15. Customers Who Never Order.sql
 
 
16. Not Boring Movies.sql
16. Not Boring Movies.sql
 
 
17. Delete Duplicate emails.sql
17. Delete Duplicate emails.sql
 
 
18. Triangle Judgement.sql
18. Triangle Judgement.sql
 
 
19. Top Travellers.sql
19. Top Travellers.sql
 
 
20. Create a Session Bar Chart.sql
20. Create a Session Bar Chart.sql
 
 
21. Biggest Single Number.sql
21. Biggest Single Number.sql
 
 
22. Reformat Department Table.sql
22. Reformat Department Table.sql
 
 
23. IMDb Genre.sql
23. IMDb Genre.sql
 
 
24. IMDb Max Weighted Rating.sql
24. IMDb Max Weighted Rating.sql
 
 
25. Article.sql
25. Article.sql
 
 
26. The Latest Login in 2020.sql
26. The Latest Login in 2020.sql
 
 
27. Recyclable and Low Fat Products.sql
27. Recyclable and Low Fat Products.sql
 
 
28. Orders With Maximum Quantity Above Average.sql
28. Orders With Maximum Quantity Above Average.sql
 
 
29. Employees Earning More Than Their Manager.sql
29. Employees Earning More Than Their Manager.sql
 
 
30. Fix Names in a Table.sql
30. Fix Names in a Table.sql
 
 
31. Friend Request.sql
31. Friend Request.sql
 
 
32. Number of Comments per Post.sql
32. Number of Comments per Post.sql
 
 
33. Consecutive Available Seats.sql
33. Consecutive Available Seats.sql
 
 
34. Find the Team Size.sql
34. Find the Team Size.sql
 
 
35. Rising Temperature.sql
35. Rising Temperature.sql
 
 
36. Warehouse Manager.sql
36. Warehouse Manager.sql
 
 
37. Running Total for Different Genders.sql
37. Running Total for Different Genders.sql
 
 
38. Patients With a Condition.sql
38. Patients With a Condition.sql
 
 
39. Ad-Free Sessions.sql
39. Ad-Free Sessions.sql
 
 
40. Queries Quality and Percentage.sql
40. Queries Quality and Percentage.sql
 
 
41. Sellers With No Sales.sql
41. Sellers With No Sales.sql
 
 
42. Percentage of Users Attended a Contest.sql
42. Percentage of Users Attended a Contest.sql
 
 
43. Winning Candidate.sql
43. Winning Candidate.sql
 
 
44. Number of Calls Between Two Persons.sql
44. Number of Calls Between Two Persons.sql
 
 
45. Product's Worth Over Invoices.sql
45. Product's Worth Over Invoices.sql
 
 
46. Confirmation of Signups.sql
46. Confirmation of Signups.sql
 
 
47. Apples & Oranges.sql
47. Apples & Oranges.sql
 
 
README.md
README.md
 
 

Repository files navigation

SQL-Problem-Solving

  • In this repository, I'll be uploading all the SQL problems I have attempted.
  • All of these problems are from CodeStudio's Top 100 SQL Problems.

About

Compilation of solutions of all the coding problems of CodeStudio's 'Top 100 SQL Problems'.

www.codingninjas.com/codestudio/problem-lists/top-100-sql-problems

Topics

sql

Resources

Readme
Activity

Stars

0 stars

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published