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.
It will pass the test, but with example from the output
"66406 17973 Rose 111 39 156 56
66556 79153 Angela 0 0 11 10
94828 80275 Frank 150 38 41 15"-It will not work.
Below is my code, but output is not passing the test.
SELECT VS_C.CONTEST_ID, CON.HACKER_ID, CON.NAME,VS_C.TS,VS_C.TAS, VS_C.TV,VS_C.TUV
FROM CONTESTS CON,
(SELECT COL1.CONTEST_ID, V_S.COL_ID, V_S.TV, V_S.TUV, V_S.TS, V_S.TAS
FROM COLLEGES COL1,
(SELECT V.COL_ID,V.TV,V.TUV,S.TS,S.TAS
FROM
(SELECT CH.COLLEGE_ID COL_ID, SUM(NVL(VS.TOTAL_VIEWS,0)) TV, SUM(NVL(VS.TOTAL_UNIQUE_VIEWS,0)) TUV
FROM VIEW_STATS VS RIGHT OUTER JOIN CHALLENGES CH ON CH.CHALLENGE_ID=VS.CHALLENGE_ID
GROUP BY COLLEGE_ID
) V,
(SELECT
CH.COLLEGE_ID COL_ID,
SUM(NVL(SS.TOTAL_SUBMISSIONS,0)) TS ,SUM(NVL(SS.TOTAL_ACCEPTED_SUBMISSIONS,0)) TAS
FROM SUBMISSION_STATS SS RIGHT OUTER JOIN CHALLENGES CH
ON SS.CHALLENGE_ID = CH.CHALLENGE_ID
GROUP BY COLLEGE_ID
) S
WHERE
V.COL_ID=S.COL_ID AND
(V.TV>0 OR
V.TUV>0 OR
S.TS>0 OR
S.TAS>0)) V_S
WHERE COL1.COLLEGE_ID=V_S.COL_ID
)VS_C
WHERE
CON.CONTEST_ID=VS_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 →
It will pass the test, but with example from the output "66406 17973 Rose 111 39 156 56 66556 79153 Angela 0 0 11 10 94828 80275 Frank 150 38 41 15"-It will not work.
Below is my code, but output is not passing the test. SELECT VS_C.CONTEST_ID, CON.HACKER_ID, CON.NAME,VS_C.TS,VS_C.TAS, VS_C.TV,VS_C.TUV FROM CONTESTS CON, (SELECT COL1.CONTEST_ID, V_S.COL_ID, V_S.TV, V_S.TUV, V_S.TS, V_S.TAS FROM COLLEGES COL1, (SELECT V.COL_ID,V.TV,V.TUV,S.TS,S.TAS FROM (SELECT CH.COLLEGE_ID COL_ID, SUM(NVL(VS.TOTAL_VIEWS,0)) TV, SUM(NVL(VS.TOTAL_UNIQUE_VIEWS,0)) TUV FROM VIEW_STATS VS RIGHT OUTER JOIN CHALLENGES CH ON CH.CHALLENGE_ID=VS.CHALLENGE_ID GROUP BY COLLEGE_ID ) V, (SELECT CH.COLLEGE_ID COL_ID, SUM(NVL(SS.TOTAL_SUBMISSIONS,0)) TS ,SUM(NVL(SS.TOTAL_ACCEPTED_SUBMISSIONS,0)) TAS FROM SUBMISSION_STATS SS RIGHT OUTER JOIN CHALLENGES CH ON SS.CHALLENGE_ID = CH.CHALLENGE_ID GROUP BY COLLEGE_ID ) S WHERE V.COL_ID=S.COL_ID AND (V.TV>0 OR V.TUV>0 OR S.TS>0 OR S.TAS>0)) V_S WHERE COL1.COLLEGE_ID=V_S.COL_ID )VS_C WHERE CON.CONTEST_ID=VS_C.CONTEST_ID;