A comprehensive journey through SQL problem-solving.
Introduction:
I've embarked on the LeetCode SQL50 challenge to enhance my SQL skills and explore a wide range of SQL concepts. This challenge covers topics like basic selects, joins, aggregate functions, sorting, grouping, advanced selects, subqueries, and string functions.
Key Learnings
So far, I've gained a solid understanding of basic SQL syntax, including SELECT, FROM, WHERE, GROUP BY, Operators and ORDER BY clauses.
Future Goals:
I plan to continue working through the SQL50 challenge and focus on more advanced topics like subqueries and string functions. I'm also interested in learning about performance optimization techniques.
Acknowledgements:
I would like to thank the LeetCode community for providing valuable resources and discussions.
Status: Inprogress
| Problem No. | Problem Title | Difficulty | Status | Solution Link |
|---|---|---|---|---|
| 1757 | Recyclable and Low Fat Products | Easy | Solved | Link to Solution |
| 584 | Find Customer Referee | Easy | Solved | Link to Solution |
| 595 | Big Countries | Easy | Solved | Link to Solution |
| 1148 | Article Views I | Easy | Solved | Link to Solution |
| 1683 | Invalid Tweets | Easy | Solved | Link to Solution |
| 1378 | Replace Employee ID with Unique Identifier | Easy | Solved | Link to Solution |
| 1068 | Product Sales Analysis | Easy | Solved | Link to Solution |
| 1581 | Customer Who Visited but Did Not Make Any Transactions | Easy | Solved | Link to Solution |
| 197 | Rising Temperature | Easy | Solved | Link to Solution |
| 1661 | Average Time of Process Per Machine | Easy | Solved | Link to Solution |
| 577 | Employee Bonus | Easy | Solved | Link to Solution |
| 1280 | Students and Examinations | Easy | Solved | Link to Solution |
| 570 | Managers with atleast 5 direct reports | Medium | Solved | Link to Solution |
| 1934 | Confirmation Rate | Medium | Solved | Link to Solution |