请问这样解有问题吗? SELECT ROUND(COUNT(l1.user_id) * 1.0 / COUNT(l2.user_id), 3) AS p FROM (SELECT user_id, min(date) AS date FROM login GROUP BY user_id) AS l2 LEFT JOIN login AS l1 ON l1.user_id = l2.user_id AND l1.date = date(l2.date,'+1 day');
点赞

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务