META Interview Question | SQL Interview Question no 16 | Daily SQL Practice | Advanced SQL

[@kanzkone2008]

This my approach: with t1 as (select count(follower_id) as Total from exo2_number), t2 as (select user_id, count(*) as total_followers from exo2_number group by user_id) select t2.user_id, (t2.total_followers * 100/t1.Total) as Percentage_user from t1 join t2

[@Thedata.techclub]

Wonderful 👍 Keep learning 😊

[@nanisai1532]

with cte as (select user_id,count(distinct follower_id) as num from famous group by user_id), cte2 as (select *,sum(num) over() as sm from cte) select user_id,(num/sm)*100 as famous from cte2

[@prami5724]

Can you give the requiter number pls

[@prami5724]

For how many years experience it is?

[@HARSHRAJ-gp6ve]

with cte as( select user_id as user_id1 FROM famous UNION select follower_id FROM famous ),cte1 as( select * FROM cte JOIN famous ON cte.user_id1=famous.user_id ORDER BY user_id1 ) select user_id1,(COUNT(*)/(select COUNT(*) FROM cte))*100 as friend_percentage FROM cte1 GROUP BY user_id1;