Q. For all employees at Northwinds, list the first name and last name concatenated together with a blank space in-between, and the YEAR when they were hired.
SELECT firstname || ' ' || lastname as "Name" from employees;
This works to get the concatenation but what to add for the hiring year?
I tried for this: –
`SELECT firstname || ' ' || lastname as "Name"
date_part('year', hiredate)
from employees;`
This didn’t work for me.
New contributor
Samruddhi Mungal is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.