CHAPTER9 Quiz

If input could be:

SELECT HospitalNumber, FirstName, FamilyName

FROM PATIENT

WHERE Consultant = 'Mr Smith';

What are the following output:

Evaluate responses using AI:

OFF

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:

Evaluate responses using AI:

OFF

Answer explanation

Using the single table database PATIENT you have created:

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

Evaluate responses using AI:

OFF

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.

Evaluate responses using AI:

OFF

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.

Evaluate responses using AI:

OFF

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.

Evaluate responses using AI:

OFF

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;

Evaluate responses using AI:

OFF

Answer explanation

Using the single table database PATIENT you have created.

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

Evaluate responses using AI:

OFF

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.

Evaluate responses using AI:

OFF

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;

Evaluate responses using AI:

OFF

Answer explanation