Using the Colonial Adcenture Tours Database from A Guide To SQL (9th Edition), C

Question

Using the Colonial Adcenture Tours Database from A Guide To SQL (9th Edition),  Create a query that includes the guide number, last name, hire date and the date of the first review, based on the hire date.

Schema:

?eject Browser ? 127.0.0.1:8080/apex/f?p-4500:1001 :3654456629742387-NO::: ORACLE Application Express Welkome COLONIAL ADVENTURE Logout Application Builder? SQL Workshop Hame S0L Workshop Object Browser Create ? APEXS ACL APEXS_WS FILES WS HSTORY APEXS WS LINKS APEXS WS NOTES APLXS_Ws ROWS APEXS WS TAGS APEKS WS WEBPG SECTIONS DEMO CUSTOMERS DEMO ORDERS DEMO ORDER ITEMS DEMO PRODUCT DEMO STATES DEMO USERS HTMLDE PLAN TABLE RESLRVATION TRIP_GUIDES Appication Lxpress 4.0 2.00.09 Wolapac COLONIAL ADVENTURE Uaer COLONIAL ADVENTURF Language en Copynght &1330, 2010, Crade All rihts eserved

Explanation / Answer

The above query will retrieve the Guide num and name along with his hiredate and the first review date. Here the first review date is given as exactly one month after his joining. For thsis we have used ADDMONTHS function which adds exactly one month to his hiredate and will display that date as his review date.

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

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