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

11) Using a subquery return all guests with reservations

12)

Create stored proc that returns all personnel and then execute it

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 +