如果无法更改数据模型，则可以使用：
SELECt user_id, MAX(event_date - prior_event_date) FROM (SELECt t.user_id, t.event_date, MAX(prior.event_date) AS prior_event_date FROM your_table AS t JOIN your_table AS prior ON (t.user_id=prior.user_idAND prior.event_date < t.event_date) GROUP BY t.user_id, t.event_date) AS events GROUP BY user_id;
如果要包含0，请使用
LEFT JOIN。
