trying stuff until it works
My solutions to SQL coding challenges on LeetCode and HackerRank.
easy
- 175. Combine Two Tables
- 176. Second Highest Salary
- 181. Employees Earning More Than Their Managers
- 182. Duplicate Emails
- 183. Customers Who Never Order
- 196. Delete Duplicate Emails
- 197. Rising Temperature
- 595. Big Countries
- 596. Classes More Than 5 Students
- 620. Not Boring Movies
- 627. Swap Salary
- 1179. Reformat Department Table
medium
easy
- Select All
- Select By ID
- Japanese Cities' Attributes
- Japanese Cities' Names
- Japan Population
- Asian Population
- African Cities
- Average Population of Each Continent
- Average Population
- Population Density Difference
- The Blunder
- Top Earners
- Higher Than 75 Marks
- Employee Names
- Employee Salaries
- Revising the Select Query I
- Revising the Select Query II
- Revising Aggregations - The Count Function
- Revising Aggregations - The Sum Function
- Revising Aggregations - Averages
- Type of Triangle
- Draw The Triangle 1
- Draw The Triangle 2
- Weather Observation Station 1
- Weather Observation Station 2
- Weather Observation Station 3
- Weather Observation Station 4
- Weather Observation Station 5
- Weather Observation Station 6
- Weather Observation Station 7
- Weather Observation Station 8
- Weather Observation Station 9
- Weather Observation Station 10
- Weather Observation Station 11
- Weather Observation Station 12
- Weather Observation Station 13
- Weather Observation Station 14
- Weather Observation Station 15
- Weather Observation Station 16
- Weather Observation Station 17