Question: You have been given the below table on transactions from users. Write a query to get the number of users and total products bought per latest transaction date where each user is bucketed into their latest(last) transaction date. Explanations & Definition: every user will have a last(lastest) transaction date, also multiple users can have the … Read more
Question: Assume you are given the below table on house prices of listed properties from various zip codes. Write a query to get the top 5 zip codes by market share of house prices for all zip codes. Also return the corresponding market share (in %, 2 decimal) as well and filter zip codes with … Read more
Question: Assume you have been given the below tables on sessions that users have generated, and a users table. Write a query to get the active user fraction of daily cohorts (acquisition date). Explanation & Definition: The date in the users table is the user acquisition date, a user acquired on a given date is … Read more
Question: Assume you are given a table for spending activity by product type. Write a query to calculate the cumulative spend for each product over time (days) in chronological order. Difficulty Level: Medium, Source: NickSingh.com, Tag: UBER SQL Interview Question Note: Cumulative sum is the same as running totals, which is used to display the data as it grows … Read more
Question: Assume you have the below ‘events’ table on app analytics. Write a query to get the click-through rate (CTR) per app in 2019. Difficulty Level: Easy, Source: NickSingh.com, Tag: Facebook SQL Interview Question Note: CTR is the number of clicks that your ad receives divided by the number of times your ad is shown. i.e CTR = total_clicks/total_ads_served … Read more
Question: Assume you are given the below tables for trades and users. Write a query to return the list of the top 3 cities with the highest number of completed order fractions. Difficulty Level: Easy, Source: NickSingh.com, Tag: Robinhood SQL Interview Question Note: completed order fraction = total completed orders / total numbers of orders … Read more