SELECT user_id, max(date) as date
FROM login
GROUP BY user_id
ORDER BY user_id