本文共 1221 字，大约阅读时间需要 4 分钟。

题目：（中等）

标签：SQL

解法一：

SELECT name AS activityFROM Activities AS A         LEFT JOIN     (SELECT activity,             COUNT(*) AS count      FROM Friends      GROUP BY activity) AS F ON A.name = F.activityWHERE IFNULL(F.count, 0) != (SELECT IFNULL(count, 0)                             FROM Activities AS A                                      LEFT JOIN                                  (SELECT activity,                                          COUNT(*) AS count                                   FROM Friends                                   GROUP BY activity) AS F ON A.name = F.activity                             ORDER BY count                             LIMIT 1)  AND IFNULL(F.count, 0) != (SELECT IFNULL(count, 0)                             FROM Activities AS A                                      LEFT JOIN                                  (SELECT activity,                                          COUNT(*) AS count                                   FROM Friends                                   GROUP BY activity) AS F ON A.name = F.activity                             ORDER BY count DESC                             LIMIT 1);

转载地址：https://dataartist.blog.csdn.net/article/details/110421059 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！