问如何比较第一次约会和最后一次约会？

EN

SELECT name
     , SEC_TO_TIME( MAX(TIME_TO_SEC(login_date))
                  - MIN(TIME_TO_SEC(login_date))
                  ) x 
  FROM my_table 
 GROUP 
    BY name;

select 
    name, 
    concat( timestampdiff( minute,
                           min( login_date ), 
                           max( login_date ) ),
            ' minutes' 
    ) as 'login duration'
from my_table
group by name

SELECT MIN(`LOGIN_DATE`), MAX(`LOGIN_DATE`) WHERE `NAME(Key)` = 'mark';