8. Colonial Adventure Tours wants to do a performance review on all its guides e

Question

8. Colonial Adventure Tours wants to do a performance review on all its guides every six months based on their hire date. Create a query that the guide number, last name, hire date and the date of the first review, based on the hire date.

Customer Customer Num LastName FirstName Address City State PostalCode Phone Reservation ReservationID TripID Trip Date Num Persons Trip Price Other Fees Customer Num Trip Guide TripID Guide Num LastName Trip Name Start Location FirstName State Address Distance City Max GrpSize State Type Postal Code Phone Num Season Hire Date TripGuides i-----. TripID Guide Num

Explanation / Answer

Query fetching information from hire_date to next 6 months...

SELECT guide_number, last_name, hire_date, review_date
FROM Guide
WHERE hire_date > dateadd(m, -6, getdate() - datepart(d, getdate()) + 1)

Related Questions

Navigate

• Browse (All)
• Browse 8
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.