Question 1. Which surgeon(s) have not booked any lease-booking? Display the results in descending order of the surgeon’s name.
Publish By:
Admin,
Last Updated:
28-Jun-23
Price:
$120
Question 1 2 Marks
Which surgeon(s) have not booked any lease-booking? Display the results in descending order of the surgeon’s name.
| SurgeonId | Name |
| 6 | Panuwat Puri |
select s.id,p.Name from Person p, Surgeon s where p.id = s.id and ( select s.ID not in (select l.SurgeonId from LeaseBooking l order by l.SurgeonId DESC ));
