Question 3. Display the details of theatres and number of lease-bookings that have the lowest number of lease-bookings.
Publish By:
Admin,
Last Updated:
28-Jun-23
Price:
$120
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
