3. (4 pts) Every guide receives their first review 6 months after their hire dat

Question

3. (4 pts) Every guide receives their first review 6 months after their hire date. List the guide's last name, first name, hire date and his/her first review date. Use FIRST REVIEW DATE as the column title. Hint: Check out section Working with Dates" in your eBook and Figure 8-3 LAST NAME FIRST NAME HIRE DATE FIRST REVIEW DATE 6/03/2012 12/03/2012 3/04/2012 00/2012 01/08/2012 07092012 104/2012 004/2013 4/08/2013 1008/2013 06/10/2013 1210/2013 09/14/2015 0314/2016 06/02/2014 12/02/2014 09/05/2014 0305/2015 02/02/2015 0802/2015 Abrams GregoryZach Susan Kely Hal Unser Lon 10 rows returned in 0.00 seconS Download Stevens Glory

Explanation / Answer

Hello Student!

Select LAST_NAME, FIRST_NAME, HIRE_DATA,  DATE_ADD(HIRE_DATA, INTERVAL 6 MONTH) AS FIRST_REVIEW_DATE FROM TABLE_NAME;

Thank you. Feel free to ask anything. Please upvote, if you like the answer. Thank you again.

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

---

---

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