Data Science Interview MasterClass

1

Question #1 Write a query to list the top 3 cities which had the highest number of completed orders.
Question #2 Write a query to get the click-through rate per app in 2019.
Question #3 Write a query to calculate the cumulative spend for each product in chronological date order.
Question #4 Write a query to get the daily new active user count
Question #5 Write a query to get the top 5 zip codes by average house prices with at least 10000 houses.
Question #6 Calculate the 7-day rolling average number of tweets by user’s age for every date.

2

Question #7 Write a query to get the monthly active user retention rate for cohort June 2019
Question #8 Write a query to get top 5 users with the longest lapse time between session. Each session’s duration must be at least 15 seconds.
Question #9 Write a query to get the number and percentage of businesses that are have 4 or 5 stars review
Question #10 Write a query to get the the percentage of time spent on sending versus opening snaps for each age group .
Question #11 Write a query to output the names of those students whose best friends got offered a higher salary than them.
Question #12 Write a SQL query that makes recommendations using the pages that your close friends liked in the last 2 weeks.
Question #13 Write a SQL query that retrieve employee ID and their skip level managers
Question #14 Write a SQL query that list out all the career path variations in the company
Question #15 Write a SQL query that show the top 5 categories that are growing 20% MoM or more with at least 10% profit margin in the last 12 months

3

Question #16 Write a query to print the respective hacker_id and name of hackers who achieved full scores for more than one challenge
Question #17 Write a query to output the start and end dates of projects listed by the number of days it took to complete the project in ascending order
Question #18 Write a query to print the contest_id, hacker_id, name, and the sums of total_submissions, total_accepted_submissions, total_views, and total_unique_views for each contest sorted by contest_id.
Question #19 Write a query to print output the session that is concurrent with the largest number of other sessions for each user.
Question #20 Write a query to get the monthly active user retention rate for every monthly cohort.

4

5

Crush SQL