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