Question 2. Which surgeons have done more than one (1) lease-booking? Display the SurgeonId, surgeon name and number of bookings.

Question 2                                                                                                                   2 Marks

Which surgeons have done more than one (1) lease-booking? Display the SurgeonId, surgeon name and number of bookings.

SurgeonId Name NumBookings
1 John Lewis 2

select s.id ,p.Name,count(l.SurgeonId) as NumBookings   from Surgeon s join LeaseBooking l

on s.id = l.SurgeonId  inner join Person p on p.id = s.Id  Group by l.SurgeonId HAVING COUNT(l.SurgeonId  ) > 1;

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