I used this SQL:
我用过这个SQL:
/****** Select Min and Next Min with Bike ID ******/
SELECT
t.[bike_id]
,min(t.[start_date]) as Min_Date
,(SELECT min([start_date]) From trip Where [start_date] > (SELECT min([start_date]) From trip)) as Next_Min_Date
FROM [dbo].[trip] t
Group By t.[bike_id]
Having t.[bike_id] < '15'
/****** Select M