# Lyft Ride Requests — SQL Interview Question

Aced (formerly Exponent) publishes a public search API over its indexed pages; the guide is at https://www.aced.io/agents/agent-access.

Source: https://www.aced.io/questions/3082/lyft-ride-requests
Source observed: 2026-11-04T21:34:35.835Z
Last checked: 2026-11-04T21:34:35.835+00:00
Indexed: 2026-11-05T02:45:22.443+00:00

---

# Lyft Ride Requests

**Difficulty:** Easy  
**Interview reports:** 4  
**Category:** Coding · SQL  
**Roles:** [Data Engineer](https://www.aced.io/questions?role=data-engineer), [Data Scientist](https://www.aced.io/questions?role=data-science), [Data Analyst](https://www.aced.io/questions?role=data-analyst)

We provide this SQL practice question for analyzing unmatched ride requests in a Lyft-style ride-sharing dataset. The question asks you to calculate each user's average number of unmatched bookings.

## Problem

Lyft connects drivers with riders. Users submit car-booking requests when they need rides. Some requests are matched with drivers, while others remain unmatched.

Use these tables:

### `users`

| Column | Description |
|---|---|
| `user_id` | Primary key and identifier for each user. |
| `user_name` | User's name. |
| `email` | User's email address. |

### `bookings`

| Column | Description |
|---|---|
| `booking_id` | Primary key and identifier for each booking. |
| `user_id` | Foreign key identifying the user who made the booking. |
| `driver_id` | ID of the assigned driver; this can be `NULL` when no driver is matched. |
| `booking_time` | Timestamp when the booking was placed. |
| `status` | Booking status, such as `Matched` or `Unmatched`. |

## Task

Write a SQL query that finds the average number of unmatched bookings per user.

Return these columns:

- `user_id`
- `user_name`
- `email`
- `avg_unmatched_bookings`, rounded to the nearest two decimal places

The question is available in the [Aced questions library](https://www.aced.io/questions) and can be practiced in the SQL editor. [Sign up to run code](https://www.aced.io/signup?src=lesson). The solution is locked behind [Upgrade](https://www.aced.io/upgrade?src=questions), and no community answers are currently contributed.

## Related courses

### [Data Analyst Interview Prep](https://www.aced.io/courses/data-analytics)

![Data Analyst Interview Prep](https://images.ctfassets.net/x78yjrjc11pq/72OTqij57b2TklhaD2vrdV/be0dae6242904970d1696e5a4d858e18/AdobeStock_1357126576.jpeg?w=800&h=800&fm=webp&q=75)

We help candidates prepare for data analyst interviews across product, marketing, and business analyst roles. The course covers real take-home case studies, technical and dashboarding skills, and strategies from interviewers at technology companies and startups.

### [Data Science Interview Prep](https://www.aced.io/courses/data-science)

![Data Science Interview Prep](https://images.ctfassets.net/x78yjrjc11pq/3U4C5C0OkDR0UeGch4AmlE/7ad489430b676a088cb973307fe77884/Data_Science_Interview_Prep_Course.jpeg?w=800&h=800&fm=webp&q=75)

We help candidates prepare for data science roles at Google, Amazon, Microsoft, Meta, Apple, and other companies. The course includes mock interviews, frameworks, and advice from senior candidates, with practice in statistics, experimentation, coding, SQL, machine learning, and behavioral interviews.

---

[Read this page’s summary](https://www.aced.io/agents/api/public/v1/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F3082%2Flyft-ride-requests&trace=t_679ff9ab98f3)

## Ask a follow-up about this page

Need a more specific answer? Ask the exact question you have. It returns a fresh, cited answer from Aced (formerly Exponent)’s knowledge base. No account or API key required.

Open this URL with your own question, URL-encoded. Include your question in q. All research inputs are optional; no account or setup.

`GET https://www.aced.io/agents/agent/faq?q={question}&trace=t_679ff9ab98f3`

[Tool guide and examples](https://www.aced.io/agents/agent-access) · [OpenAPI](https://www.aced.io/agents/api/public/v1/openapi.json) · [Page TLDR form](https://www.aced.io/agents/agent-tools/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F3082%2Flyft-ride-requests). Opening a form does not execute a tool.