Question

Consider the above tables and execute the following queries:

1. Display the count of patient room wise.

2. Display the names of patients who are admitted in room no 101.

3. Display the disease of patient whose bed_No is 1.

4. Display the room_no and bed_no of patient whose name is “Mr Roy”.

5. Give the details of Patient who is admitted on 2nd flr in roomno 102.​

Answer 1

Answer:

1.Display the count of patient room wise

Answer 2

Answer:

Give the details of Patient who is admitted on 2nd flr in roomno 102.