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.

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;