Consider A Database Name NVAEducation Whose Attributes Are #1157

Consider a database name “NVAEducation” whose attributes are intern_id (primary key), subject, subject_value.<br /> Intern_id = {1, 2, 3, 4, 5, 6}<br /> Subject = {sql, oop, sql, oop, c, c++}<br /> Subject_value = {0, 0, 1, 1, 2, 2, 3, 3}<br /> If these are one to one relation then what will be the output of the following MySQL statement?</p> <pre><code class="language-sql"> SELECT intern_id FROM nvaeducation Where subject IN (SELECT subject FROM nvaeducation WHERE subject_value IN (3, 2)); </code></pre>

This multiple choice question (MCQ) is related to the book/course gs gs113 MySQL. It can also be found in gs gs113 Nulls and Conditions and Miscellaneous - Condition Types - Quiz No.3.

 SELECT intern_id FROM nvaeducation Where subject IN (SELECT subject FROM nvaeducation WHERE subject_value IN (3, 2));