Skip to content

Latest commit

 

History

History
31 lines (28 loc) · 6.72 KB

README.md

File metadata and controls

31 lines (28 loc) · 6.72 KB

sql-pandas-practice

This repository contains solutions to questions I've attempted on StrataScratch to hone my abilities in tackling complex logic so I can get better at SQL & Pandas.

The questions have a range of various difficulties (easy - hard).

Completed Questions: 22

ID # Title Difficulty SQL Solution Pandas Solution
2002 Submission Types Easy Link Link
10176 Bikes Last Used Easy Link Link
2049 Total Order Per Status Per Service Easy Link Link
2063 Change of Currency Exchange Rates Easy Link Link
10087 Find All Posts Which Were Reacted to With A Heart Easy Link Link
10073 Favorite Host Nationality Medium Link Link
10283 Find The Top-Ranked Songs For The Past 20 Years Medium Link Link
10295 Most Active Users On Messenger Medium Link Link
9726 Classify Business Type Medium Link Link
9915 Highest Cost Order Medium Link Link
9728 Number of Violations Medium Link Link
10322 Finding User Purchases Medium Link Link
10351 Activity Rank Hard Link Link
10300 Premium vs Freemium Hard Link Link
10302 Distance Per Dollar Hard Link Link
514 Marketing Campaign Success Hard Link Link
10319 Monthly Percentage Difference Hard Link Link
9814 Counting Instances in Text Hard Link Link
9632 Host Popularity Rental Prices Hard Link Link
10284 Popularity Percentage Hard Link Link
10046 Top 5 States With 5 Stars Businesses Hard Link Link
10182 Number of Streets Per Zip Code Hard Link Link