My SQL practice repository with solutions to StrataScratch problems, organized by difficulty (Easy, Medium, Hard).
| # | Title | Solution |
|---|---|---|
| 001 | LinkedIn β Calculates the difference between salaries | View |
| 002 | Microsoft β Current salary per employee | View |
| 003 | Amazon β Job titles of the highest-paid employees | View |
| 004 | DoorDash β Last time each bike was in use | View |
| 005 | Glassdoor β Compare salary with department average | View |
| 006 | Apple β Customers with or without orders | View |
| 007 | Amazon β Workers joined on or after April 1, 2014 | View |
| 008 | Apple β Unique users per client by month | View |
| 009 | Airbnb β Average bathrooms and bedrooms | View |
| 010 | Spotify β Songs ranked in the top position | View |
| 011 | Spotify β How many times each artist appeared | View |
| 012 | Lyft β Drivers with extreme salaries | View |
| 013 | Meta β Average Hack popularity by location | View |
| 014 | Shopify β Orders made by Jill and Eva | View |
| 015 | Amazon β Number of shipments per month | View |
| 016 | Apple β MacBookPro user events | View |
| 017 | Forbes β Most profitable financial company | View |
| 018 | City of Los Angeles β Inspection date & risk for STREET CHURROS | View |
| 019 | City of San Francisco β Number of violations at Roxanne Cafe | View |
| 020 | Microsoft β Admin employees joined in April or later | View |
(to be added later)
(to be added later)