leetcode

commit a2005ad7688f83194620b633cf07b729751d6705
parent ba76f37f4141b4ef1d48ecee03a3ba64766293d0
Author: AndrewLockVI <andrewlaack1@gmail.com>
Date:   Mon, 10 Jul 2023 08:15:04 -0500

Completed find followers count using mySQL

Diffstat:
A
find-followers-count/find-followers-count.sql
 | 
6
++++++

1 file changed, 6 insertions(+), 0 deletions(-)
diff --git a/find-followers-count/find-followers-count.sql b/find-followers-count/find-followers-count.sql
@@ -0,0 +1,6 @@
+--Find the number of followers each user has
+
+SELECT Followers.user_id, COUNT(Followers.user_id) followers_count
+FROM Followers
+GROUP BY Followers.user_id
+ORDER BY Followers.user_id