Friend Requests II: Who Has the Most Friends | Leetcode 602 | Crack SQL Interviews in 50 Qs

[@learnwithchirag]

Hey there! 👋 For more interesting content, tutorials, and updates, Feel free to connect with me on
Instagram Handles :-
@createwithchirag - instagram.com/createwithchirag/
@learn.with.chirag - instagram.com/learn.with.chirag/
LinkedIn: www.linkedin.com/in/chirag-sehgal-9200111b8/
Let's stay connected and keep the creativity flowing! 💡

[@apoorvpradhan5125]

Thanks bhaiya.

[@nimbu_03]

bro, u really explained it well ! Best sql series on internet !

[@learnwithchirag]

Thanks a ton !....Do share with everyone 😄

[@DIVYANSHAJAY]

Nice Work sir! 👍

[@learnwithchirag]

Glad you liked it.
Keep Supporting 💯

[@prathamsharma4416]

loving you series

[@HarshalDevre-x8w]

@Learn With Chirag why this problem cant be solved using self join plz answer

[@khush.sandhu]

Thanks

[@learnwithchirag]

Glad it was helpful to you! 😄

[@ChandanSahoo-yi2tv]

WITH cte AS (
SELECT requester_id AS id FROM RequestAccepted
UNION ALL
SELECT accepter_id AS id FROM RequestAccepted
)
SELECT id, count(id) AS num FROM cte GROUP BY id ORDER BY count(id) DESC LIMIT 1;