SQL
LeetCode selected problems
Only high-quality problems are selected. Pathological problems and entry-level syntax problems are not included.
And ‘solution’ column will be updated once I start to work on ‘em!
# | Problems | Solution | Level | Concept |
---|---|---|---|---|
262 | Trips and Users | 🤭 | Hard | Three-way join; filtering |
185 | Department Top Three Salaries | 🤭 | Hard | Non-equijoin; aggregation; window functionsample |
579 | Cumulative Salary of Employee | 🤭 | Hard | Self-join; left join; aggregation |
601 | Human Traffic of Stadium | 🤭 | Hard | Self-join; de-duplication; window |
615 | Average Salary | 🤭 | Hard | Case; aggregation, join |
618 | Students Report By Geography | 🤭 | Hard | Full join, pivoting |