Basics of Sets and Relations #7 – HackerRank Solution

In this post, we will solve Basics of Sets and Relations #7 HackerRank Solution. This problem (Basics of Sets and Relations #7) is a part of HackerRank Databases series.

Task

Consider the following data table named Student.

Student Name        Number  Sex  
Nina                3412    F 
Mike                1234    M  
Nelson              2341    F  

Here is another data table named Teaching Assistants

Subject     ID
Physics     3412
Chemistry   1111
Mathematics 2341  

What is the count of rows returned in the following join operation?
Student _{⊳⊲(Number=ID)} Teaching Assistants

Only enter a single integer. Do not include any extra spaces or newlines.

Solution – Basics of Sets and Relations #7 – HackerRank Solution

2

Note: This problem (Basics of Sets and Relations #7) is generated by HackerRank but the solution is provided by CodingBroz. This tutorial is only for Educational and Learning purpose.