Practice Interview Questions
| Question | Status |
|---|---|
Assume you are on Waymo’s Data Science team, and you want to analyze customer metrics related to the Waymo One service.
Given the customers and rides tables, write a SQL query to find the percentage of customers who signed up for Waymo One and took at least one ride.
customers table:
| Column Name | Description |
|---|---|
| customer_id | Unique identifier for customers |
| business_or_personal | Indicates type of account |
rides table:
| Column Name | Description |
|---|---|
| ride_id |
Assume you are on Waymo’s Data Science team, and you want to analyze customer metrics related to the Waymo One service.
Given the customers and rides tables, write a SQL query to find the percentage of customers who signed up for Waymo One and took at least one ride.
customers table:
| Column Name | Description |
|---|---|
| customer_id | Unique identifier for customers |
| business_or_personal | Indicates type of account |
rides table:
| Column Name | Description |
|---|---|
| ride_id |
| Unique identifier for rides |
| date | Date of the ride |
| customer_id | Unique identifier for customers |
| ride_miles | Distance of the ride in miles |
| ride_minutes | Duration of the ride in minutes |
| percentage |
|---|
| 0.8178 |
| Unique identifier for rides |
| date | Date of the ride |
| customer_id | Unique identifier for customers |
| ride_miles | Distance of the ride in miles |
| ride_minutes | Duration of the ride in minutes |
| percentage |
|---|
| 0.8178 |