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 ct.contest_id,hacker_id,name,sum(total_submissions),sum(total_accepted_submissions),sum(total_views),sum(total_unique_views)
from contests ct
join colleges cl
on ct.contest_id=cl.contest_id
join challenges chl
on cl.college_id=chl.college_id
left join
(select challenge_id,sum(total_views) as total_views, sum(total_unique_views) as total_unique_views
from view_stats vw_st
group by challenge_id
) as r
on r.challenge_id=chl.challenge_id
left join
(select challenge_id, sum(total_submissions) as total_submissions, sum(total_accepted_submissions) as total_accepted_submissions
from submission_stats sub
group by challenge_id) as s
on s.challenge_id=chl.challenge_id
group by ct.contest_id,hacker_id,name
order by ct.contest_id,hacker_id,name
Interviews
You are viewing a single comment's thread. Return to all comments →
select ct.contest_id,hacker_id,name,sum(total_submissions),sum(total_accepted_submissions),sum(total_views),sum(total_unique_views) from contests ct join colleges cl on ct.contest_id=cl.contest_id join challenges chl on cl.college_id=chl.college_id left join (select challenge_id,sum(total_views) as total_views, sum(total_unique_views) as total_unique_views from view_stats vw_st group by challenge_id ) as r on r.challenge_id=chl.challenge_id left join (select challenge_id, sum(total_submissions) as total_submissions, sum(total_accepted_submissions) as total_accepted_submissions from submission_stats sub group by challenge_id) as s on s.challenge_id=chl.challenge_id group by ct.contest_id,hacker_id,name order by ct.contest_id,hacker_id,name