Feb 17 · 2 min read · Date: February 17, 2026Category: SQLTime Taken: 30 minutesDifficulty: Hard Problem Statement The cancellation rate is computed by dividing the number of canceled (by client or driver) requests with unbanned users by the total number of requests with...
Join discussionFeb 16 · 2 min read · Date: February 16, 2026Category: SQLTime Taken: 15 minutesDifficulty: Hard Problem Statement Write a solution to display the records with three or more rows with consecutive id's, and the number of people is greater than or equal to 100 for each. Re...
Join discussionFeb 12 · 1 min read · Date: February 12, 2026Category: SQLTime Taken: 10 minutesDifficulty: Medium Problem Statement Write a solution to report the customer ids from the Customer table that bought all the products in the Product table. Link: Customers Who Bought All Prod...
Join discussionFeb 12 · 2 min read · Date: February 12, 2026Category: SQLTime Taken: 10 minutesDifficulty: Easy Problem Statement Write a solution to find the daily active user count for a period of 30 days ending 2019-07-27 inclusively. A user was active on someday if they made at lea...
Join discussionFeb 11 · 2 min read · Date: February 09, 2026Category: SQLTime Taken: 15 minutesDifficulty: Medium Problem Statement Write a solution to swap the seat id of every two consecutive students. If the number of students is odd, the id of the last student is not swapped. Retur...
Join discussionFeb 11 · 2 min read · Date: February 11, 2026Category: SQLTime Taken: 10 minutesDifficulty: Medium Problem Statement Each node in the tree can be one of three types: "Leaf": if the node is a leaf node. "Root": if the node is the root of the tree. "Inner": If the node ...
Join discussionFeb 9 · 2 min read · Date: February 09, 2026Category: SQLTime Taken: 15 minutesDifficulty: Medium Problem Statement Write a solution to find the people who have the most friends and the most friends number. The test cases are generated so that only one person has the mo...
Join discussionFeb 9 · 2 min read · Date: February 09, 2026Category: SQLTime Taken: 15 minutesDifficulty: Medium Problem Statement Write a solution to report the sum of all total investment values in 2016 tiv_2016, for all policyholders who: have the same tiv_2015 value as one or mor...
Join discussionFeb 7 · 2 min read · Date: February 07, 2026Category: ArraysTime Taken: 30 minutesDifficulty: Medium Problem Statement Given an array of intervals where intervals[i] = [start<sub>i</sub>, end<sub>i</sub>], merge all overlapping intervals, and return an array of the non-...
Join discussionFeb 6 · 2 min read · Date: February 06, 2026Category: SQLTime Taken: 20 minutesDifficulty: Medium Problem Statement Write a solution to report the fraction of players that logged in again on the day after the day they first logged in, rounded to 2 decimal places. In oth...
Join discussion
