Question 3 2 Marks
Display the details of theatres and number of lease-bookings that have the lowest number of lease-bookings.
TheatreId | TheatreName | NumBookings |
2 | West | 1 |
select l.TheatreId, t.TheatreName, count(l.TheatreId) as NumBookings from Theatre t join LeaseBooking l on t.id = l.TheatreId Group by l.TheatreId Having Count(l.TheatreId) <=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