Question 1. Which surgeon(s) have not booked any lease-booking? Display the results in descending order of the surgeon’s name.

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 ));

Expert's Answer

help

Hire Expert 

Get a Professional Help


200
Select FileChangeRemove

TOP