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.
We Join the tables using two columns Number and ID.The Join would bring the values which are present in both the tables where the values in Number column matches with the value in ID column.In our case,we have two matching values(3412 and 2341) and so the final output would contain 2 rows with all the columns from both these tables.Since they have asked the count the answer is 2.
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Basics of Sets and Relations #7
You are viewing a single comment's thread. Return to all comments →
We Join the tables using two columns Number and ID.The Join would bring the values which are present in both the tables where the values in Number column matches with the value in ID column.In our case,we have two matching values(3412 and 2341) and so the final output would contain 2 rows with all the columns from both these tables.Since they have asked the count the answer is 2.