Car Rental Utilization by City: The SQL Question That Separates Seniors

00:00 Car Rental Utilization Interview Question 00:20 Why Counting Rentals Is Wrong 00:50 The Correct Metric: Rented Time / Available Time 01:20 Tables and Assumptions 01:50 Handling Open Rentals with COALESCE 02:20 Capping Utilization at 100% 02:50 Per-Car Aggregation Before City Aggregation 03:20 Final SQL Solution 03:50 Common Mistakes and Interview Tips https://github.com/vishnoiprem/data-e... #SQL #DataEngineering #DataAnalytics #SQLInterview #MetaInterview #Prachub #CodingInterview #TechInterview #DataScientist #AnalyticsEngineering