This repository contains solutions to SQL query challenges from platforms such as LeetCode and StrataScratch (with more to come in the future). The focus is not only on solving the problems but also on writing optimised, readable, and maintainable code.
- Clear & Structured Solutions: Prioritize readability without sacrificing efficiency.
- Performance-Oriented: Where relevant, solutions are optimized for execution time and scalability.
- Learning-Oriented: Complex topics are broken down into approachable explanations outside the codebase.
- Browse to the platform directory of interest.
- Open the corresponding
.sqlfile for the query solution. - For extended explanations of concepts, check the linked Notion page.
The aim is to treat query challenges as an opportunity to practice problem-solving with intent:
- Write code that is easy to understand for others (and future self).
- Consider efficiency as an integral part of the solution.
- Reflect on the underlying concepts and document them when necessary.