Slip 3 - D) Consider the above tables and execute the following queries: 1. Display the names of the hospitals which are located at “Pimpri” city. 2. Display the names of doctors who are working in “Birla” Hospital and city name is “Chinchwad”. 3. Display the specialty of the doctors who are working in “Ruby” hospital. 4. Give the count of doctor’s hospital wise which are located at “Pimple Gurav”. 5. Update an address of Doctor to “Pimpri” whose hospital is “Ruby clinic”.

Solution:



Post a Comment

0 Comments