TSupioads.SS.aiTiazollavS.COT 4.(4 pts) Repeat the previous question but display

Question

TSupioads.SS.aiTiazollavS.COT 4.(4 pts) Repeat the previous question but display the guides' names as first name followed by last name (for example, Rita Boyers). Use NAME as the column title for the guides' names. NAME Mles Abrams 06/03/2012 12030012 Rita Boyers cou 2012 0%042012 Harley Devon 01/082012 07/08/2012 ach Gregory 1104/2012 0604/2013 Susan Kley 04/082013 100/2013 Sam Keby 0w10 2013 12/10 2013 Ray Mrston ?/142015 03-42016 Hal Rowan 06/02/2014 12/02/2014 Leni Stevens 05/2014 03/05/2015 Glory Unser 02/02/2015 0802/2015 10 rows returned in 0 00 seconds Da RE DATE FIRST REVIEW DATE Hint: Check out section "Concatenating Columns" in your eBook and Figure 8-6. Put your SQL command and results here:

Explanation / Answer

SELECT CONCAT(FIRSTNAME, ' ', LASTNAME) AS 'NAME',HIRE_DATE,FIRS_REVIEW_DATE FROM guide;

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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