重点：group by having的句法

SELECT 
    COUNT(1) as times
FROM
(
    SELECT 
        login_date, 
        COUNT(login_time) AS cnt
    FROM 
        logintb 
    GROUP BY user_id, login_date 
    HAVING cnt >= 2
) a;