stratascratch-practice

Repository contains the practice questions solved on Stratascratch

Coding Questions

MS SQL Server

Question	Link to question	Difficulty
Gender With Most Doctor Appointments	https://platform.stratascratch.com/coding/10170-gender-with-most-doctor-appointments	Easy
Number Of Records By Variety	https://platform.stratascratch.com/coding/10168-number-of-records-by-variety	Easy
Count the number of movies that Abigail Breslin nominated for oscar	https://platform.stratascratch.com/coding/10128-count-the-number-of-movies-that-abigail-breslin-nominated-for-oscar	Easy
Account Registrations	https://platform.stratascratch.com/coding/2126-account-registrations	Easy
Mobile and Web Logins	https://platform.stratascratch.com/coding/2080-mobile-and-web-logins	Easy
Salaries Differences	https://platform.stratascratch.com/coding/10308-salaries-differences	Easy
Finding Updated Records	https://platform.stratascratch.com/coding/10299-finding-updated-records	Easy
Find all inspections which are part of an inactive program	https://platform.stratascratch.com/coding/10277-find-all-inspections-which-are-part-of-an-inactive-program	Easy
Order all countries by the year they first participated in the Olympics	https://platform.stratascratch.com/coding/10184-order-all-countries-by-the-year-they-first-participated-in-the-olympics	Easy
Total Cost Of Orders	https://platform.stratascratch.com/coding/10183-total-cost-of-orders	Easy
Bikes Last Used	https://platform.stratascratch.com/coding/10176-bikes-last-used	Easy
Find all posts which were reacted to with a heart	https://platform.stratascratch.com/coding/10087-find-all-posts-which-were-reacted-to-with-a-heart	Easy
Find the average distance traveled in each hour	https://platform.stratascratch.com/coding/10006-find-the-average-distance-traveled-in-each-hour	Easy
Hour Of Highest Gas Expense	https://platform.stratascratch.com/coding/10005-hour-of-highest-gas-expense	Easy
Find all Lyft rides which happened on rainy days before noon	https://platform.stratascratch.com/coding/10004-find-all-lyft-rides-which-happened-on-rainy-days-before-noon	Easy
Lyft Driver Wages	https://platform.stratascratch.com/coding/10003-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	https://platform.stratascratch.com/coding/9861-find-the-number-of-employees-in-each-department	Easy
Find the average of inspections scores between 91 and 100	https://platform.stratascratch.com/coding/9707-find-the-average-of-inspections-scores-between-91-and-100	Easy
Find the number of inspections per day	https://platform.stratascratch.com/coding/9704-find-the-number-of-inspections-per-day	Easy
Find the most common grade earned by bakeries	https://platform.stratascratch.com/coding/9703-find-the-most-common-grade-earned-by-bakeries	Easy
Find the average score for grades A, B, and C	https://platform.stratascratch.com/coding/9693-find-the-average-score-for-grades-a-b-and-c	Easy
Find all routine inspections where high-risk issues were found	https://platform.stratascratch.com/coding/9690-find-all-routine-inspections-where-high-risk-issues-were-found	Easy
Inspection For Glassell Coffee Shop	https://platform.stratascratch.com/coding/9689-inspection-for-glassell-coffee-shop	Easy
Count the number of user events performed by MacBookPro users	https://platform.stratascratch.com/coding/9653-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-yelp	Easy
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	https://platform.stratascratch.com/coding/10143-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	https://platform.stratascratch.com/coding/2055-average-customers-per-city	Medium

PySpark

Question	Link to question	Difficulty

|