题解 | #灵魂社交APP单日登录次数大于等于2次的用户数#
灵魂社交APP单日登录次数大于等于2次的用户数
http://www.nowcoder.com/practice/8d32ba60eb314d3a8a2c0b1285b9bb9c
重点：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;
查看11道真题和解析