Question: Which is the best SQL statement for selecting only the table data for patients with last name Jones and age > 6 0 ? Group

Which is the best SQL statement for selecting only the table data for patients with last name Jones and age >60?
Group of answer choices
a. Select * from patient
b. Select * from patient where age >60
c. Select * from patient where last_name =Jones
d. Select * from patient where age >60 and last_name =Jones

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!