CHAPTER9 Quiz

If input could be:

SELECT HospitalNumber, FirstName, FamilyName

FROM PATIENT

WHERE Consultant = 'Mr Smith';

What are the following output:

Answer explanation

If input could be:

SELECT HospitalNumber, FirstName, FamilyName

FROM PATIENT

WHERE Consultant = 'Mr Smith'

ORDER BY FamilyName;

What are the following output could be:

Answer explanation

Using the single table database PATIENT you have created:

Write an SQL query to list all Mr Jones’ patients.

Answer explanation

SELECT FirstName, FamilyName

FROM PATIENT

WHERE Consultant = 'Mr Jones'; 

Using the single table database PATIENT you have created. Write an SQL query to list all the patients not in ward 6.

Answer explanation

SELECT FirstName, FamilyName

FROM PATIENT

WHERE WardNumber <> 6; 

Using the single table database PATIENT you have created.

Write an SQL query to list all the patients who arrived on 12/11/2022.

Answer explanation

SELECT FirstName, FamilyName

FROM PATIENT

WHERE DateOfAdmisson = '12/11/2022’; 

Using the single table database PATIENT you have created.

Write an SQL query to list all the patients who arrived between 12/10/2022 AND 30/10/2022.

Answer explanation

SELECT FirstName, FamilyName, DateOfAdmission  

FROM PATIENT

WHERE DateOfAdmission >= '12/10/2022' AND DateOfAdmission <= '30/10/2022’ ; 

Using the single table database PATIENT you have created.

Write down the output from this SQL query.

SELECT FirstName, FamilyName, BedNumber

FROM PATIENT

WHEREWardNumber= 7;

Answer explanation

Using the single table database PATIENT you have created.

Write an SQL query to count the number of patients in ward 7.

Answer explanation

SELECT Count (WardNumber) 

FROM PATIENT

WHEREWardNumber= 7;

Using the single table database PATIENT you have created.

Write an SQL query to count the number of patients not in ward 7.

Answer explanation

SELECT Count (WardNumber) 

FROM PATIENT

WHEREWardNumber<> 7;

Using the single table database PATIENT you have created.

Write down the output from this SQL query.

SELECT HospitalNumber, FirstName, FamilyName, Consultant

FROM PATIENT

ORDER BY Consultant, FamilyName;

Answer explanation