This repository consists of all the SQL solutions with intuitive explanations that I have done from multiple resources (including supplemental readings about some functions and operators used). The solutions are either for MySQL or PostgreSQL which I will make a note before the solution.
- Challenges *Using multiple Correlated Subquery, HAVING clause, and IN operator
- Occupations *Using User-Defined Variables and CASE WHEN
- Ollivander's Inventory *Using Correlated Subquerry
- The PADS *Using CONCAT function
- The Report *Using IF and JOIN
- Top Competitors *Using multiple INNER JOIN functions
- Type of Triangle *Using IF function