Leetcode Problem 1729. Find Followers Count

1729. Find Followers Count

Leetcode Solutions

Use the SELECT statement to specify the columns to be retrieved, which are user_id and the count of followers (aliased as followers_count).
Use the FROM clause to specify the Followers table as the source of the data.
Apply the GROUP BY clause to group the results by user_id, which will allow the COUNT function to calculate the number of followers for each user.
Use the ORDER BY clause to sort the results by user_id in ascending order.

erDiagram
    Followers {
        int user_id
        int follower_id
        user_id & follower_id PK
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen