根据user_id分组汇总，选出user_id和date的最大值，并按user_id排序

select user_id, max(date) as d from login
group by user_id
order by user_id