Question: Assume you are given the below table on watch times (in minutes) for all users, where each user is based in a given city. Write a query to return all pairs of cities with total watch times within 10000 minutes of one another. Difficulty Level: Easy, Source: Nicksingh, Tag: Disney SQL Interview Question Assumptions: No NULLS present; DBMS: … Read more
Question: Assume you are given the below table on purchases from users. Write a query to get the number of users that purchased at least one product on multiple days. Explanation & Definition: basically you are required to find those users having more than 1 purchase dates. Difficulty Level: Easy, Source: NickSingh, Tag: Amazon SQL Interview Question Assumptions: No … Read more
Question: Assume you are given the below tables on users and user posts. Write a query to get the distribution of the number of posts per user for each given day. Explanation & Definition: Each user will have a certain post count for each day, by daily distribution we mean for each day we need the … Read more