Skip to content

Daily practice of SQL & Python (pandas) on for continuous improvement.

License

Notifications You must be signed in to change notification settings

adamyangyang/sql-pandas-practice

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

86 Commits
 
 
 
 
 
 
 
 

Repository files navigation

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

About

Daily practice of SQL & Python (pandas) on for continuous improvement.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages