write SQL code for the following queries tables are tblGuest, tblPropertybackup, tblPersonnel, tblReservation, tblWork

6) WHERE tblGuest.GuestID = tblReservation.GuestID AND tblProperty.PropertyID = tblReservation.PropertyID;

7) Returns all guests without reservations

8) Properties without reservations

9) Using a subquery return all reservations that have more than the average number of people

10)Now add the the firstname and lastname to the previous query

dbo.tblGuest Columns GuestID (nvarchar(3), null) GuestFirstName (nvarchar(20), null) GuestLastName (nvarchar(25), null) Address (nvarchar(32), null) City (nvarchar(24), null) StateProv (nvarchar(2), null) Postal Code (nvarchar(10), null) Country (nvarchar(15), null) Phone (nvarchar(14), null) dbo.tblPersonnel Columns PersonlD (nvarchar(6), null) FirstName (nvarchar(14), null) LastName (nvarchar(14), null) Job Title (nvarchar(22), null) Manager (nvarchar(6), null) dbo.tblProperty Columns PropertyID (nvarchar(4), null) PropertyName (nvarchar(45), null) Location (nvarchar(35), null) Country (nvarchar(15), null) NightlyRate (money, null) Bedrooms (smallint, null) Sleeps (smallint, null) Property Type (nvarchar(20), null) Description (nvarchar(max), null) dbo.tblReservation Columns ReservationID (nvarchar(3), null) GuestID (nvarchar(3), null) PropertyID (nvarchar(4), null) StartDate (datetime, null) EndDate (datetime, null) People (smallint, null) RentalRate (money, null) Kevs +