Question: A10. Consider the following schema STUDENTS(student code, first name, last name, email, phone no, date of birth, MS subject, percentage of marks); Which of the
A10. Consider the following schema STUDENTS(student code, first name, last name, email, phone no, date of birth, MS subject, percentage of marks); Which of the following query would display names of all the students whose MS subject is English and percentage of marks more than 70, or MS subjectis French and percentage of marks more than 70? "English" or A. select first name, last name from students where MS subject MS subject - "French and percentage of marks > 70; B. select first name, last name from students where (MS subject MS subject - "French" and percentage of marks > 70; C. select first name, last name from students where (MS. subject MS subject - "French" and percentage of marks > 70); D. select first name, last name from students where (MS subject MS.subject = "French" and percentage of marks > 70; "English" or "English" or "English") or
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
