Consider the following
schema –

STUDENTS (student_code, first_name, last_name, email, phone_no, date_of_birth, honours_subject, percentage_of_marks); Which of the following
query would display the names of all the students whose honours subject is English
and percentage of marks more than 80, or honours subject is Spanish and
percentage of marks more than 80?

Question

Consider the following
schema –

STUDENTS  (student_code, first_name, last_name, email, phone_no, date_of_birth, honours_subject, percentage_of_marks);  Which of the following
query would display the names of all the students whose honours subject is English
and percentage of marks more than 80, or honours subject is Spanish and
percentage of marks more than 80?

Answer

C.  select first_name, last_name from students where (honours_subject =
“English” or honours_subject = “Spanish” and percentage_of_marks > 80);

Answer

D.  select first_name, last_name from students where (honours_subject
= “English” or honours_subject = “Spanish”) and percentage_of_marks > 80;

Answer

B.  select first_name, last_name from students where (honours_subject =
“English”) or honours_subject = “Spanish” and percentage_of_marks > 80;

Answer

A.  select first_name, last_name from students where honours_subject =
“English” or honours_subject = “Spanish” and percentage_of_marks > 80;

Crowdly

Consider the following schema – STUDENTS (student_code, first_name, last_...

Want instant access to all verified answers on moodle.usth.edu.vn?