You are viewing a single comment's thread. Return to all comments →
Hints:
Not necessary that all CHALLENGE_ID have a value in VIEW_STATS and/or SUBMISSION_STATS. (LEFT JOIN)
Treat each table SUMs individually (VIEW_STATS[total_views, total_unique_views], SUBMISSION_STATS[total_submissions, total_accepted_submissions])
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 →
Hints:
Not necessary that all CHALLENGE_ID have a value in VIEW_STATS and/or SUBMISSION_STATS. (LEFT JOIN)
Treat each table SUMs individually (VIEW_STATS[total_views, total_unique_views], SUBMISSION_STATS[total_submissions, total_accepted_submissions])