Question 1 Retrieve the first and last names and department

Question 1. Retrieve the first and last names and department
number and name of all employees directly supervised by James Borg.
Show results in ascending alpha order (by last name and then first
name).

Column Headings: FNAME LNAME DNUMBER DNAME

Solution

select FNAME,LNAME,DNUMBER,DNAME
from TABLE_NAME where DNAME = \'James Borg\'
order by LNAME,FNAME;