SELECT member_srl, COUNT(*) AS login_count

FROM xe_member_autologin

GROUP BY member_srl

ORDER BY login_count DESC;

날짜도 추가

SELECT member_srl, MAX(regdate) AS last_login, COUNT(*) AS login_count

FROM xe_member_autologin

GROUP BY member_srl

ORDER BY login_count DESC;