Slip 4 - D) 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.

Solution:

Post a Comment

0 Comments