Consider the query : SELECT student_name FROM students WHERE class_name=(SELECT class_name FROM students WHERE math_marks=100); what will be the output ?
A. the list of names of students with 100 marks in mathematics
B. the names of all students of all classes in which at least one student has 100 marks in mathematics
C. the names of all students in all classes having 100 marks in mathematics
D. the names and class of all students whose marks in mathematics is 100
Answer:B
Consider the query : SELECT student_name FROM students WHERE class_name=(SELECT class_name FROM students WHERE math_marks=100); what will be the output ?
A. the list of names of students with 100 marks in mathematics B. the names of all students of all classes in which at least one student has 100 marks in mathematics C. the names of all students in all classes having 100 marks in mathematics D. the names and class of all students whose marks in mathematics is 100