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
![Experts](https://assignmentstudio.net/wp-content/uploads/2021/08/Experts-300x126_c.png)
Your future, our responsibilty submit your task on time.
Order NowGet Online
Assignment Help Services