• + 0 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