Skip to content

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