StrataScratch practice exercise - with MS SQL Server
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 |