/* Query 8 (page 137, 222 of the text book)

   For each employee, retrieve the employee's first and last name and
   the first and last name of his/her immediate supervisor.

   The result must be
	'John'	'Smith'	'Franklin'	'Wong'
	'Franklin'	'Wong'	'James'	'Borg'
	'Alicia'	'Zelaya'	'Jennifer'	'Wallace'
	'Jennifer'	'Wallace'	'James'	'Borg'
	'Ramesh'	'Narayan'	'Franklin'	'Wong'
	'Joyce'	'English'	'Franklin'	'Wong'
	'Ahmad'	'Jabbar'	'Jennifer'	'Wallace'
*/

select e.fname, e.lname, s.fname, s.lname
from employee e, employee s
where e.superssn = s.ssn ;
