I strongly believe that there should be 25 SQL patterns that if any data scientist understands, they should be fine for 80% of their data querying, manipulation, and analysis needs.
This repository sets out to accomplish that goal by providing a curated list of 25 essential SQL patterns. For each pattern there will be:
- The SQL code
- Readme markdown that is a description of
- Real word use case of the pattern
- How to identify the pattern in any situation