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)