Question Link to question Difficulty

Gender With Most Doctor Appointments Gender With Most Doctor Appointments Easy
Number Of Records By Variety Number Of Records By Variety Easy
Count the number of movies that Abigail Breslin nominated for oscar Count the number of movies that Abigail Breslin nominated for oscar Easy
Account Registrations Account Registrations Easy
Mobile and Web Logins StrataScratch - Mobile and Web Logins Easy
Salaries Differences Salaries Differences Easy
Finding Updated Records Finding Updated Records Easy
Find all inspections which are part of an inactive program Find all inspections which are part of an inactive program Easy
Order all countries by the year they first participated in the Olympics Order all countries by the year they first participated in the Olympics Easy
Total Cost Of Orders Total Cost Of Orders Easy
Bikes Last Used Bikes Last Used Easy
Find all posts which were reacted to with a heart Find all posts which were reacted to with a heart Easy
Find the average distance traveled in each hour Find the average distance traveled in each hour Easy
Hour Of Highest Gas Expense Hour Of Highest Gas Expense Easy
Find all Lyft rides which happened on rainy days before noon Find all Lyft rides which happened on rainy days before noon Easy
Lyft Driver Wages Lyft Driver Wages Easy
QBs With Most Interceptions https://platform.stratascratch.com/coding/9969-qbs-with-most-interceptions Easy
Top 10 QBs https://platform.stratascratch.com/coding/9962-top-10-qbs Easy
Total Employees in Each Department Total Employees in Each Department Easy
Find the average of inspections scores between 91 and 100 Find the average of inspections scores between 91 and 100 Easy
Find the number of inspections per day Find the number of inspections per day Easy
Find the most common grade earned by bakeries Find the most common grade earned by bakeries Easy
Find the average score for grades A, B, and C Find the average score for grades A, B, and C Easy
Find all routine inspections where high-risk issues were found Find all routine inspections where high-risk issues were found Easy
Inspection For Glassell Coffee Shop StrataScratch - Inspection For Glassell Coffee Shop Easy
Count the number of user events performed by MacBookPro users Count the number of user events performed by MacBookPro users Easy
Oregon's Prior Month's Sales https://platform.stratascratch.com/coding/2160-oregons-prior-months-sales Easy
Active Users Per Platform https://platform.stratascratch.com/coding/2072-active-users-per-platform Easy
Total Shipment Weight https://platform.stratascratch.com/coding/2058-total-shipment-weight Easy
Weight For First Shipment https://platform.stratascratch.com/coding/2057-weight-for-first-shipment Easy
Unique Users Per Client Per Month https://platform.stratascratch.com/coding/2024-unique-users-per-client-per-month Easy
Total Number Of Housing Units https://platform.stratascratch.com/coding/10167-total-number-of-housing-units Easy
Sorting By Second Character https://platform.stratascratch.com/coding/2166-sorting-by-second-character Easy
Admin Department Employees Beginning in April or Later https://platform.stratascratch.com/coding/9845-find-the-number-of-employees-working-in-the-admin-department
Easy
Customer Details https://platform.stratascratch.com/coding/9891-customer-details Easy
Number of Shipments Per Month https://platform.stratascratch.com/coding/2056-number-of-shipments-per-month Easy
Reviews of Hotel Arena https://platform.stratascratch.com/coding/10166-reviews-of-hotel-arena Easy
3 Bed Minimum https://platform.stratascratch.com/coding/9627-3-bed-minimum Easy
Cheapest Properties https://platform.stratascratch.com/coding/9625-cheapest-properties Easy
Dirty Hotel Rooms https://platform.stratascratch.com/coding/9602-dirty-hotel-rooms Easy
Find all neighborhoods present in this dataset https://platform.stratascratch.com/coding/9626-find-all-neighborhoods-present-in-this-dataset Easy
Total AdWords Earnings https://platform.stratascratch.com/coding/10164-total-adwords-earnings Easy
Number Of Acquisitions https://platform.stratascratch.com/coding/10162-number-of-acquisitions Easy
Pending Claims https://platform.stratascratch.com/coding/2083-pending-claims Easy
Number of Hires During Specific Time Period https://platform.stratascratch.com/coding/2151-number-of-hires-during-specific-time-period Easy
Rank guests based on their ages https://platform.stratascratch.com/coding/10160-rank-guests-based-on-their-ages Easy
Find the number of Yelp businesses that sell pizza https://platform.stratascratch.com/coding/10153-find-the-number-of-yelp-businesses-that-sell-pizza Easy
Find the review count for one-star businesses from yelp https://platform.stratascratch.com/coding/10050-find-the-review-count-for-one-star-businesses-from-yelpEasy
Gender With Generous Reviews https://platform.stratascratch.com/coding/10149-gender-with-generous-reviews Easy
Guest Or Host Kindness https://platform.stratascratch.com/coding/10072-guest-or-host-kindness Easy
Find players who participated in the Olympics representing more than one team Find players who participated in the Olympics representing more than one team Easy
Even-numbered IDs Hired in June https://platform.stratascratch.com/coding/10137-find-workers-with-an-even-number-for-worker-id Easy
First Name's Containing the Letter 'a' https://platform.stratascratch.com/coding/9840-find-all-workers-whose-first-name-contains-the-letter-a Easy
First Names With Six Letters Ending in 'h' https://platform.stratascratch.com/coding/9842-find-all-workers-whose-first-name-contains-6-letters-and-also-ends-with-the-letter-h
Easy
Odd-numbered ID's Hired in February https://platform.stratascratch.com/coding/10136-find-workers-with-an-odd-number-for-worker-id Easy
Positions Of Letter 'a' https://platform.stratascratch.com/coding/9829-positions-of-letter-a Easy
Highest Crime Rate https://platform.stratascratch.com/coding/10132-highest-crime-rate Easy
METROPOLITAN TRANSIT AUTHORITY' Employees https://platform.stratascratch.com/coding/9975-metropolitan-transit-authority-employees Easy
Calculate Samantha's and Lisa's total sales revenue https://platform.stratascratch.com/coding/10127-calculate-samanthas-and-lisas-total-sales-revenue Easy
Find the total number of searches for houses Westlake neighborhood with a TV https://platform.stratascratch.com/coding/10122-find-the-total-number-of-searches-for-houses-westlake-neighborhood-with-a-tv
Easy
Number Of Bathrooms And Bedrooms https://platform.stratascratch.com/coding/9622-number-of-bathrooms-and-bedrooms Easy
User Exile https://platform.stratascratch.com/coding/10091-user-exile Easy
Popularity of Hack https://platform.stratascratch.com/coding/10061-popularity-of-hack Easy
Find the number of reviews received by Lo-Lo's Chicken & Waffles for each star https://platform.stratascratch.com/coding/10058-find-the-number-of-reviews-received-by-lo-los-chicken-waffles-for-each-star
Easy
Find the number of 5-star reviews earned by Lo-Lo's Chicken & Waffles https://platform.stratascratch.com/coding/10057-find-the-number-of-5-star-reviews-earned-by-lo-los-chicken-waffles
Easy
Find the number of entries per star https://platform.stratascratch.com/coding/10054-find-the-number-of-entries-per-star Easy
Churro Activity Date https://platform.stratascratch.com/coding/9688-churro-activity-date Easy
BAKERY' Owned Facilities https://platform.stratascratch.com/coding/9697-bakery-owned-facilities Easy
Find all actions which occurred more than once in the weblog https://platform.stratascratch.com/coding/9771-find-all-actions-which-occurred-more-than-once-in-the-weblog
Easy
Find all messages which have references to either user 2 or 3 https://platform.stratascratch.com/coding/9767-find-all-messages-which-have-references-to-either-user-2-or-3
Easy
Find all users who liked a post https://platform.stratascratch.com/coding/9769-find-all-friends-who-liked-a-post Easy
Total Salary by Department https://platform.stratascratch.com/coding/9869-find-the-total-salary-of-each-department Medium
Most Profitable Companies https://platform.stratascratch.com/coding/10354-most-profitable-companies Medium
Workers With The Highest Salaries https://platform.stratascratch.com/coding/10353-workers-with-the-highest-salaries Medium
Average On-Time Order Value https://platform.stratascratch.com/coding/2153-average-on-time-order-value Medium
Users By Average Session Time https://platform.stratascratch.com/coding/10352-users-by-avg-session-time Medium
Activity Rank https://platform.stratascratch.com/coding/10351-activity-rank Medium
Distances Traveled https://platform.stratascratch.com/coding/10324-distances-traveled Medium
Most Profitable City of 2021 https://platform.stratascratch.com/coding/2137-most-profitable-city-of-2021 Medium
Algorithm Performance https://platform.stratascratch.com/coding/10350-algorithm-performance Medium
Finding User Purchases https://platform.stratascratch.com/coding/10322-finding-user-purchases Medium
Find the percentage of shipable orders https://platform.stratascratch.com/coding/10090-find-the-percentage-of-shipable-orders Medium
New Products https://platform.stratascratch.com/coding/10318-new-products Medium
Daily Active Users https://platform.stratascratch.com/coding/2050-daily-active-users Medium
Duplicate Emails https://platform.stratascratch.com/coding/9895-duplicate-emails Medium
Highest Target https://platform.stratascratch.com/coding/9904-highest-target Medium
Cities With The Most Expensive Homes https://platform.stratascratch.com/coding/10315-cities-with-the-most-expensive-homes Medium
Class Performance https://platform.stratascratch.com/coding/10310-class-performance Medium
Risky Projects https://platform.stratascratch.com/coding/10304-risky-projects Medium
Average Customers Per City Average Customers Per City Medium