Distance Traveled
Given the tables users and rides, write a query to report the distance traveled by each user in descending order.
Example:
Input:
users table
| Column | Type |
|---|---|
id |
INTEGER |
name |
INTEGER |
rides table
| Column | Type |
|---|---|
id |
INTEGER |
passenger_user_id |
INTEGER |
distance |
FLOAT |
Output:
| Column | Type |
|---|---|
name |
VARCHAR |
distance_traveled |
FLOAT |
Good job, keep it up!
35%
CompletedYou have 54 sections remaining on this learning path.
Loading pricing options