20. Bikes Last Time Used

Grokking SQL for Tech Interviews

Ask Author

Back to course home

0% completed

Table of Contents

Contents are not accessible

Problem

Table: Bikes

+-------------+----------+ 
| Column Name | Type     | 
+-------------+----------+ 
| ride_id     | int      | 
| bike_number | text     | 
| start_time  | datetime |
| end_time    | datetime |
+-------------+----------+
ride_id column contains unique values.
Each row contains a ride information that includes ride_id, bike number, start and end time of the ride.

Problem Definition

Write a solution to find the last time when each bike was used.

Return the result table ordered by the bikes that were most recently used.

Example

Output

.....

Like the course? Get enrolled and start learning!

Table of Contents

Contents are not accessible