Changes

J.Y.S

9 bytes added, 22:58, 19 October 2010

→‎4.

''James''

<pre>

select substr(first_name ||' '|| last_name) "Employee", job_id, to_char(salary, '$999,999', 12, '=') Salary, department_name

from employees e join departments d

on (e.department_id = d.department_id)

1

edit