Skip to content

My SQL practice repository with solutions to StrataScratch problems, organized by difficulty (Easy, Medium, Hard).

Notifications You must be signed in to change notification settings

AntoninaData/SQL_for_Data_Analytics

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

19 Commits
Β 
Β 
Β 
Β 

Repository files navigation

πŸ“Š # SQL_for_Data_Analytics

My SQL practice repository with solutions to StrataScratch problems, organized by difficulty (Easy, Medium, Hard).


🟒 EASY 🟒

# 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

🟑 MIDDLE 🟑

(to be added later)

πŸ”΄ HARD πŸ”΄

(to be added later)

About

My SQL practice repository with solutions to StrataScratch problems, organized by difficulty (Easy, Medium, Hard).

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published