Skip to content

Repository contains the practice questions solved on Stratascratch

Notifications You must be signed in to change notification settings

akshayavb99/stratascratch-practice

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 

Repository files navigation

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

|

About

Repository contains the practice questions solved on Stratascratch

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published