Question: Write SQL commands to make the following queries: List the first and last names of all patients who had a Clinical Test named X-Ray. Avoid
Write SQL commands to make the following queries: List the first and last names of all patients who had a Clinical Test named X-Ray. Avoid patient duplications and use the WHERE" and "FROM" clause with the information provided below.



I get the following after I run it and not sure what to input, My table comes back blankplease help.



Physician \begin{tabular}{|l|l|l|l|l|l|} \hline FirstName & LastName & ID & Specialty & Phone & Salary \\ \hline \end{tabular} ClinicalTests Query1 SELECT FirstName, LastName FROM Patient P, Consultation C, RequestedClinicalTests R, ClinicalTests CT WHERE P.SSN = C.PatientSSN AND R.ConsultationID = C.ConsultationID AND Enter Parameter V... ?X C.testID = R.TestID AND C.Name = "X-Ray"; C.testiD Query1 SELECT FirstName, LastName FROM Patient P, Consultation C, RequestedClinicalTests R, ClinicalTests CT WHERE P.SSN = C.PatientSSN AND R.ConsultationID = C.ConsultationID AND Enter Parameter V... ?X C.testID = R.TestID AND C.Name = "X-Ray"; C.Name
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
