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.
Can someone correct this -
WITH total as
(
select challenge_id, SUM(v.total_views),SUM(v.total_unique_views),
SUM(s.total_submissions), SUM(s.total_accepted_submissions)
from View_Stats v
JOIN Submission_Stats s
group by challenge_id
)
select cs.,c.,cl.,t. from Contests cs
join Colleges c on cs.contest_id = c.contest_id
join Challenges cl on c.challenge_id = cl.challenge_id
join total t on cl.challenge_id = t.challenge_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 →
Can someone correct this - WITH total as ( select challenge_id, SUM(v.total_views),SUM(v.total_unique_views), SUM(s.total_submissions), SUM(s.total_accepted_submissions) from View_Stats v JOIN Submission_Stats s group by challenge_id ) select cs.,c.,cl.,t. from Contests cs join Colleges c on cs.contest_id = c.contest_id join Challenges cl on c.challenge_id = cl.challenge_id join total t on cl.challenge_id = t.challenge_id