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

help

Hire Expert 

Get a Professional Help


200
Select FileChangeRemove

TOP