Q7
Date & Time
25 stations · 3.9hDate arithmetic, ranges, day/week/month bucketing and comparing consecutive days. 25 interview problems explained by Everyday Data Science (3.9h of video), grouped into 2 patterns such as Date ranges & intervals, Date parts & bucketing.
Start this line →- Date ranges & intervals6
- Date parts & bucketing9
- Other11
Date ranges & intervals
0 of 6 passed- List the Products Ordered in a PeriodLC 1327 · 7:07EasyAmazon · MicrosoftLeetCode ↗ (opens in a new tab)
- User Activity for the Past 30 Days ILC 1141 · 6:12EasyGoogle · Amazon · +4 more companiesLeetCode ↗ (opens in a new tab)
- Friendly Movies Streamed Last MonthLC 1495 · 6:46 · LeetCode PremiumEasyAmazonLeetCode ↗ (opens in a new tab)
- User Activity for the Past 30 Days IILC 1142 · 7:13 · LeetCode PremiumEasyMeta · ZoomLeetCode ↗ (opens in a new tab)
- Users With Two Purchases Within Seven DaysLC 2228 · 10:03 · LeetCode PremiumMediumAmazonLeetCode ↗ (opens in a new tab)
- Calculate Orders Within Each IntervalLC 2893 · 4:33 · LeetCode PremiumMediumLeetCode ↗ (opens in a new tab)
Date parts & bucketing
0 of 9 passed- Unique Orders and Customers Per MonthLC 1565 · 9:54 · LeetCode PremiumEasyLeetCode ↗ (opens in a new tab)
- Monthly Transactions ILC 1193 · 9:00MediumGoogle · Amazon · +5 more companiesLeetCode ↗ (opens in a new tab)
- Friendly Movies Streamed Last MonthLC 1495 · 6:46 · LeetCode PremiumEasyAmazonLeetCode ↗ (opens in a new tab)
Other
0 of 11 passed- Users That Actively Request Confirmation MessagesLC 1939 · 11:22 · LeetCode PremiumEasyLeetCode ↗ (opens in a new tab)
- Rising TemperatureLC 197 · 9:40EasyGoogle · Amazon · +10 more companiesLeetCode ↗ (opens in a new tab)
- The Number of Users That Are Eligible for DiscountLC 2205 · 7:06 · LeetCode PremiumEasyAnalytics quotientLeetCode ↗ (opens in a new tab)
- The Users That Are Eligible for DiscountLC 2230 · 6:22 · LeetCode PremiumEasyAnalytics quotientLeetCode ↗ (opens in a new tab)
- Employees With DeductionsLC 2394 · 10:02 · LeetCode PremiumMediumAmazonLeetCode ↗ (opens in a new tab)
- Calculate Parking Fees and DurationLC 3166 · 16:04 · LeetCode PremiumMediumLeetCode ↗ (opens in a new tab)
- Number of Accounts That Did Not StreamLC 2020 · 6:09 · LeetCode PremiumMediumWarnermediaLeetCode ↗ (opens in a new tab)
All 25 stations in order
- 1.Unique Orders and Customers Per Month (LeetCode 1565)
- 2.The Latest Login in 2020 (LeetCode 1890)
- 3.Convert Date Format (LeetCode 1853)
- 4.List the Products Ordered in a Period (LeetCode 1327)
- 5.Customer Order Frequency (LeetCode 1511)
- 6.Monthly Transactions I (LeetCode 1193)
- 7.Sales by Day of the Week (LeetCode 1479)
- 8.Tasks Count in the Weekend (LeetCode 2298)
- 9.User Activity for the Past 30 Days I (LeetCode 1141)
- 10.Friendly Movies Streamed Last Month (LeetCode 1495)
- 11.User Activity for the Past 30 Days II (LeetCode 1142)
- 12.Users That Actively Request Confirmation Messages (LeetCode 1939)
- 13.Rising Temperature (LeetCode 197)
- 14.Users With Two Purchases Within Seven Days (LeetCode 2228)
- 15.The Number of Users That Are Eligible for Discount (LeetCode 2205)
- 16.The Users That Are Eligible for Discount (LeetCode 2230)
- 17.Employees With Deductions (LeetCode 2394)
- 18.New Users Daily Count (LeetCode 1107)
- 19.Second Day Verification (LeetCode 3172)
- 20.Calculate Parking Fees and Duration (LeetCode 3166)
- 21.Friday Purchases I (LeetCode 2993)
- 22.Unpopular Books (LeetCode 1098)
- 23.Number of Accounts That Did Not Stream (LeetCode 2020)
- 24.Calculate Orders Within Each Interval (LeetCode 2893)
- 25.Monthly Transactions II (LeetCode 1205)