Company SQL Question
Latest Trip for Each Rider
Practice this Uber style SQL interview question with live execution and instant feedback.
Problem Statement
Find the latest trip per rider using a correlated subquery on MAX(pickup_datetime).
Relevant Tables
riderstrips
SQL Concepts Used in This Question
Strengthen your understanding with these targeted learning topics: