Interviews | 42/100 Days Of SQL Challenge | HackerRank Solution

[@HARSHRAJ-gp6ve]

Thank you sir

[@Loner-j8b]

why can't we do the joins in this way?
select
c.contest_id,
c.hacker_id,
c.name,
sum(s.total_submissions),
sum(s.total_accepted_submissions),
sum(v.total_views),
sum(v.total_unique_views)
from
contests c
join
colleges c2
on
c.contest_id=c2.contest_id
join
challenges c3
on
c2.college_id=c3.college_id
join
view_stats v
on
c3.challenge_id=v.challenge_id
join
submission_stats s
on
v.challenge_id=s.challenge_id

[@VISHALKUMAR-gw8wx]