w3resource
SQL exercises

SQL exercises on hospital Database: Find the name of the patients and the number of the room where they have to go for their treatment

SQL hospital Database: Exercise-15 with Solution

15. Write a query in SQL to find the name of the patients and the number of the room where they have to go for their treatment.

Sample table: patient


Sample table: appointment


Sample Solution:

SELECT p.name AS "Patient",
       a.examinationroom AS "Room No.",
       a.start_dt_time AS "Date and Time of appointment"
FROM patient p
JOIN appointment a ON p.ssn=a.patient;

Sample Output:

      Patient      | Room No. | Date and Time of appointment
-------------------+----------+------------------------------
 John Smith        | A        | 2008-04-24 10:00:00
 Grace Ritchie     | B        | 2008-04-24 10:00:00
 John Smith        | A        | 2008-04-25 10:00:00
 Dennis Doe        | B        | 2008-04-25 10:00:00
 Dennis Doe        | C        | 2008-04-26 10:00:00
 Random J. Patient | C        | 2008-04-26 11:00:00
 John Smith        | C        | 2008-04-26 12:00:00
 Dennis Doe        | A        | 2008-04-27 10:00:00
 Grace Ritchie     | B        | 2008-04-27 10:00:00
(9 rows)

Practice Online


E R Diagram of Hospital Database:

E R Diagram: SQL Hospital Database.

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a query in SQL to count number of unique patients who got an appointment for examination room C.
Next: Write a query in SQL to find the name of the nurses and the room scheduled, where they will assist the physicians.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming