Interview Guides
You are given Lyft trip records and city metadata. Write a PostgreSQL query that cleans inconsistent trip status values, joins each trip to its city, and summarizes operational performance by city for January 2024. Use the cleaned status logic to count completed trips and calculate completed-trip revenue, while excluding canceled and unknown statuses from the completed metrics.
