Mysql How to display the number of authorizations (count) per user?

Question

MySQL

There is a database with fields Auth_date, Login, IP, each time we log in, we add data there.
Tell me how to display the number of authorizations per user?

Answer 1

COUNT, GROUP BY

Answer 2

SELECT
    u.login,
    count(a.auth_date)
FROM
    users u
    JOIN auth_table a ON u.login = a.login
WHERE
    -- какое-то условие
GROUP BY u.login