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

Hire Expert Tutors

Get Professional Tutoring at Low Price in Australia


Academic Excellence
Professional
Tutoring Services
👥

25k+

Sessions Done

4.9/5

Student Rating

👨‍🏫

600+

Expert Tutors

Why Learn With Us?

🧠

Concept Clarity

🎯

Personalized Plan

💸

Affordable Rates

📅

Flexible Schedule

📈

Results Driven

💬

24/7 Support

You may also like

TOP