Interview Guides
You are given Lyft ride and customer data. Write a PostgreSQL query that compares key ride metrics across customer segments in a single result set. Your output should show one row per segment with total rides, completed rides, canceled rides, and average completed fare.
Use the segment from the customer profile, and include only rides created in January 2024. The result should be ordered by total rides descending, then segment name ascending.
