These are scripts that answer questions from StrataScratch. Links to questions and my answers are below!
| ID | Title | My Solution |
|---|---|---|
| 10363 | Weekly Orders Report | SQL |
| 10356 | Finding Doctors | SQL |
| 10308 | Salaries Differences | SQL |
| 10299 | Finding Updated Records | SQL |
| 10183 | Total Cost Of Orders | SQL |
| 10170 | Gender With Most Doctor Appointments | SQL |
| 10164 | Total AdWords Earnings | SQL |
| 10153 | Find the number of Yelp businesses that sell pizza | SQL |
| 10147 | Find countries that are in winemag_p1 dataset but not in winemag_p2 | SQL |
| 10132 | Highest Crime Rate | SQL |
| 10128 | Count the number of movies that Abigail Breslin nominated for oscar | SQL |
| 10127 | Calculate Samantha's and Lisa's total sales revenue | SQL |
| 10122 | Find the total number of searches for houses Westlake neighborhood with a TV | SQL |
| 10087 | Find all posts which were reacted to with a heart | SQL |
| 10057 | Find the number of 5-star reviews earned by Lo-Lo's Chicken & Waffles | SQL |
| 10055 | Records With '?' | SQL |
| 10054 | Find the number of entries per star | SQL |
| 10052 | Find the average number of stars for each state | SQL |
| ID | Title | My Solution |
|---|---|---|
| 10368 | Population Density | SQL |