Compiling the solutions of SQL questions, that I solved on leetcode and hackerrank.
Topic : Basic Joins
| Question | Solution | Level |
|---|---|---|
| Replace Employee ID With The Unique Identifier | Solution | Easy |
| Customer Who Visited but Did Not Make Any Transactions | Solution | Easy |
| Average time of process per machine | Solution | Easy |
| Employee Bonus | Solution | Easy |
| Students and Examinations | Solution | Easy |
Topic : Sorting & Grouping
| Question | Solution | Level |
|---|---|---|
| Number of Unique Subjects Taught by Each Teacher | Solution | Easy |
| User Activity for the Past 30 Days I | Solution | Easy |
| Product Sales Analysis -III | Solution | Medium |
| Classes More Than 5 Students | Solution | Easy |
| Find Followers Count | Solution | Easy |
| Biggest Single Number | Solution | Easy |
| Product Sales Analysis 1 | Solution | Easy |