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.
Hint 1: Perform a LEFT JOIN on View_Stats and another LEFT JOIN on Submission_Stats (this means you need to handle NULL values).
Hint 2: After performing the LEFT JOIN on both View_Stats and Submission_Stats, you may encounter duplicated data. It is advisable to sum the values from View_Stats and Submission_Stats in their own subqueries before doing the LEFT JOIN to avoid errors due to duplication.
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 →
Hint 1: Perform a LEFT JOIN on View_Stats and another LEFT JOIN on Submission_Stats (this means you need to handle NULL values).
Hint 2: After performing the LEFT JOIN on both View_Stats and Submission_Stats, you may encounter duplicated data. It is advisable to sum the values from View_Stats and Submission_Stats in their own subqueries before doing the LEFT JOIN to avoid errors due to duplication.