Use an aggregate function to select the largest km value.

Make sure to pick MAX(km).