I am trying to retrieve the full name (concatenated and with a column header), job title, department id, department name and salary for all employees from the database and nothing I try seems to work.

```
select first_name ||' '|| last_name "Full Name", department_id, salary from employees

```

This is as far as I got since the department\_name is from the departments table and the job\_title is from the jobs table. The rest is from the employees table and that's why this part works. can anyone help me?