18. Percentage of Users Attended a Contest Leetcode | SQL Interview Questions and Answers

[@siddharthkhandelwal933]

Thanks! Your videos really helped me

[@StartPracticing]

Your welcome 🙂

[@chahatupadhyay1307]

Can you explain why you use select with count(user_id) as denominator of percentage calculation is their any other way to do the same?

[@MdSalman-no1zc]

Percentage= (Any one event/Total event)*100 🤔

[@sheelusaini6710]

ye 2 ke bad ka jo bracket close kiya the wo open hi nhi kiya phir ye divide m hai to count ke sath jo bracket use kiya hai wo 2 ke sath kaise use kr skte hai

[@StartPracticing]

Wo bracket round function ke liye hai jo 2 ke baad close kiye hai

[@saipradeep01]

here 208 and 209 and 210 had 100% but why 208 is top why not 209 and 210

[@ankitraj4179]

confusing tha..select use samjh nhi aaya

[@MdSalman-no1zc]

Maam q copy paste kr rahi ho "distinct user_id" ka logic batao na

[@fari_edu2020]

Distinct keyword is not required here as contest-id and user-id is a composite primary key.

[@rupamsingh3691]

There are two tables, so why didn't you use joins?

[@iam_kazmi]

++

[@StartPracticing]

✌