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,

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!