/Stratascratch_interview_prep

Stratascratch interview preparation with both python (pandas) and SQL

Primary LanguagePython

# ID Title SQL Solution Python Solution Difficulty
1 9633 City With Most Amenities MySQL Python(pandas) Hard
2 9700 Rules To Determine Grades MySQL Python(pandas) Medium
3 10319 Monthly Percentage Difference MySQL Python(pandas) Hard
4 2033 Find The Most Profitable Location MySQL Python(pandas) Hard
5 10322 Finding User Purchases MySQL Python(pandas) Medium
6 10061 Popularity of Hack MySQL Python(pandas) Easy
7 10128 Count the number of movies that Abigail Breslin nominated for oscar MySQL Python(pandas) Easy
8 10285 Acceptance Rate By Date MySQL Python(pandas) Medium
9 10314 Revenue Over Time MySQL Python(pandas) Hard
10 9895 Duplicate Emails MySQL Python(pandas) Easy
11 9806 Find_all_records_with_words_that_start_with_the_letter 'g'. MySQL Python(pandas) Hard
12 10302 Distance Per Dollar MySQL Python(pandas) Hard
13 10017 Year Over Year Churn MySQL Python(pandas) Hard
14 2052 User Growth Rate MySQL Python(pandas) Easy
15 2059 Player with Longest Streak MySQL Python(pandas) Hard
16 9697 BAKERY Owned Facilities MySQL Python(pandas) Easy
17 10041 Most Expensive And Cheapest Wine MySQL Python(pandas) Hard
18 10352 Users By Average Session Time MySQL Python(pandas) Medium
19 10354 most-profitable-companies MySQL Python(pandas) Medium
20 10084 Cum Sum Energy Consumption MySQL Python(pandas) Hard
21 10064 Highest Energy Consumption MySQL Python(pandas) Medium
22 10353 Workers With The Highest Salaries MySQL Python(pandas) Medium
23 10164 Total AdWords Earnings MySQL Python(pandas) Easy
24 9794 Words With Two Vowels MySQL Python(pandas) Hard
25 10353 Workers With The Highest Salaries MySQL Python(pandas) Medium
26 10300 Premium vs Freemium MySQL Python(pandas) Hard
27 10313 Naive Forecasting MySQL Python(pandas) Hard
28 10308 Salaries Differences MySQL Python(pandas) Easy
29 10351 Activity Rank MySQL Python(pandas) Medium
30 9903 Employees With Bonuses MySQL Python(pandas) Easy
31 514 Marketing Campaign Success MySQL Python(pandas) Hard
32 9773 Day 1 Common Reactions MySQL Python(pandas) Medium
33 2001 Share of Loan Balance MySQL Python(pandas) Medium