We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
select c.contest_id , c.hacker_id, c.name
,sum(total_submissions)
,sum(total_accepted_submissions)
,sum(total_views)
,sum(total_unique_views)
from Contests c join Colleges co on c.contest_id = co.contest_id
join Challenges ch on co.college_id = ch.college_id
left join
(select challenge_id, sum(total_views) as total_views, sum(total_unique_views) as total_unique_views
from View_Stats group by challenge_id) vs
on ch.challenge_id = vs.challenge_id
left join (select challenge_id, sum(total_submissions) as total_submissions , sum(total_accepted_submissions) as total_accepted_submissions
from Submission_Stats group by challenge_id) ss
on ch.challenge_id = ss.challenge_id
group by c.contest_id, c.hacker_id, c.name
having sum(total_submissions) != 0 or
sum(total_accepted_submissions) != 0 or
sum(total_views) !=0 or
sum(total_unique_views) !=0
order by c.contest_id
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Interviews
You are viewing a single comment's thread. Return to all comments →
select c.contest_id , c.hacker_id, c.name ,sum(total_submissions) ,sum(total_accepted_submissions) ,sum(total_views) ,sum(total_unique_views) from Contests c join Colleges co on c.contest_id = co.contest_id join Challenges ch on co.college_id = ch.college_id left join (select challenge_id, sum(total_views) as total_views, sum(total_unique_views) as total_unique_views from View_Stats group by challenge_id) vs on ch.challenge_id = vs.challenge_id left join (select challenge_id, sum(total_submissions) as total_submissions , sum(total_accepted_submissions) as total_accepted_submissions from Submission_Stats group by challenge_id) ss on ch.challenge_id = ss.challenge_id group by c.contest_id, c.hacker_id, c.name having sum(total_submissions) != 0 or sum(total_accepted_submissions) != 0 or sum(total_views) !=0 or sum(total_unique_views) !=0 order by c.contest_id