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

 
 
 

Contributors