What is wrong with this answer?


  • 0
    T

    8 / 13 test cases passed. I don't understand.

    SELECT f1.follower, COUNT(f2.follower) num
    FROM follow f1 JOIN follow f2
    ON f1.follower = f2.followee
    GROUP BY f1.follower
    ORDER BY f1.follower;
    

  • 0
    D

    May have this kind of case, some row have same followee and follower, see below

    | followee | follower |
    +-------------+------------+
    | A | B |
    | B | C |
    | B | C |
    | B | D |
    | D | E |
    +-------------+------------+


  • 0
    L

    There are duplicate records in the table.


Log in to reply
 

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.