mysql如何写一句sql查询近三个月内，最后一次登陆时间距今超过14天的用户ID

Question

用户ID字段为uuid

最后一次登录时间字段为utime

Answer 1

select a.uuid from table_name where ctime BETWEEN date_add(now(), interval -3 MONTH) AND now() GROUP BY uuid HAVING datediff(now(),max(ctime))>14