My Profile: https://platform.stratascratch.com/user/yeungbur
A place to store my SQL solutions to practice problems from StrataScratch!
https://platform.stratascratch.com/coding
| ID | Title | My Solution |
|---|---|---|
| 514 | Marketing Campaign Success | SQL |
| 2059 | Player with Longest Streak | SQL |
| 9632 | Host Popularity Rental Prices | SQL |
| 9688 | Churro Activity Date | SQL |
| 9915 | Highest Cost Orders | SQL |
| 10046 | Top 5 States With 5 Star Businesses | SQL |
| 10284 | Popularity Percentage | SQL |
| 10300 | Premium vs Freemium | SQL |
| 10319 | Monthly Percentage Difference | SQL |
| ID | Title | My Solution |
|---|---|---|
| 9650 | Find the top 10 ranked songs in 2010 | SQL |
| 9653 | Count the number of user events performed by MacBookPro users | SQL |
| 9680 | Most Profitable Companies | SQL |
| 9726 | Classify Business Type | SQL |
| 9728 | Number of violations | SQL |
| 9781 | Find the rate of processed tickets for each type | SQL |
| 9782 | Customer Revenue In March | SQL |
| 9894 | Employee and Manager Salaries | SQL |
| 9897 | Highest Salary In Department | SQL |
| 9905 | Highest Target Under Manager | SQL |
| 9913 | Order Details | SQL |
| 9942 | Largest Olympics | SQL |
| 9991 | Top Ranked Songs | SQL |
| 10048 | Top Businesses With Most Reviews | SQL |
| 10049 | Reviews of Categories | SQL |
| 10060 | Top Cool Votes | SQL |
| 10064 | Highest Energy Consumption | SQL |
| 10071 | Hosts' Abroad Apartments | SQL |
| 10073 | Favorite Host Nationality | SQL |
| 10077 | Income By Title and Gender | SQL |
| 10078 | Find matching hosts and guests | SQL |
| 10156 | Number Of Units Per Nationality | SQL |
| 10159 | Ranking Most Active Guests | SQL |
| 10285 | Acceptance Rate By Date | SQL |
| 10322 | Finding User Purchases | SQL |
| 10352 | Users By Avg Session time | SQL |
| 10353 | Workers With The Highest Salaries | SQL |
| 10354 | Most Profitable Companies | SQL |
| ID | Title | My Solution |
|---|---|---|
| 9622 | Number Of Bathrooms And Bedrooms | SQL |
| 9891 | Finding Updated Records | SQL |
| 9917 | Average Salaries | SQL |
| 9963 | Most Profitable with Continent | SQL |
| 10003 | Lyft Driver Wages | SQL |
| 10061 | Popularity of Hack | SQL |
| 10087 | Find all posts which were reacted to with a heart | SQL |
| 10176 | Bikes Last Used | SQL |
| 10299 | Finding Updated Records | SQL |
| 10308 | Salaries Differences | SQL |