What does the following query do?select name, ID, branchfrom student, departmentwhere student.branch = department.branch;

• A. It gives all values of name, ID, branch from both the relations only if all those attributes are present in both
• B. It gives all values of name, ID, branch from their respective relations
• C. It gives the values of name, ID, branch from their respective relations where the values in the branch attribute are same
• D. It gives the values of name, ID, branch from their respective relations where all the values are matching with each other