sql - 2个表之间的简单SQL选择查询

Question

我有2张 table

First table - userTable

usedID  userName
1          someName
2          someOthername

Second Table - ratingTable

userID ratingValue
1          5
1          3
1          5
1          3
2          5
2          5
2          3
2          5

我需要编写一个 SQL 查询，以按评级次数(5 星)升序获取所有用户 ID

Answer 1

SELECT u.userID, u.userName, COUNT(*) AS ratingCount
    FROM userTable u
        INNER JOIN ratingTable r
            ON u.userID = r.userID
                AND r.ratingValue = 5
    GROUP BY u.userID, u.userName
    ORDER BY ratingCount