Question 3. Display the details of theatres and number of lease-bookings that have the lowest number of lease-bookings.

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

Hire Expert Tutors

Get Professional Tutoring at Low Price in Australia


Professional

Tutoring Services

25,187+

Orders Delivered

4.9/5

5 Star Rating

621

PhD Experts

 

Amazing Features

Plagiarism Free

Top Quality

Best Price

On-Time Delivery

100% Money Back

24 x 7 Support

TOP