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
Chat with our Experts
Want to contact us directly? No Problem. We are always here for you
Your future, our responsibilty submit your task on time.
Order NowGet Online
Assignment Help Services