/* Show the employee data. */

select * from employee;


/* Show employees and their supervisors.  Show IDs and last names. */

select ...
from  employee subordinate, employee supv
where subordinate.emp_supv = supv.emp_id;


select sub.emp_id as "Sub ID", 
  sub.emp_fname + ' ' + sub.emp_lname as "Subordinate", 
  supv.emp_id as "Supv ID", 
  supv.emp_fname + ' ' + supv.emp_lname as "Supervisor"
from  employee sub, employee supv
where sub.emp_supv = supv.emp_id;


/* List evaluatees and evaluators. Show the evaluation ID, student
IDs and full names.  */

select eval_ID,
  evaluatee.stdid as "Evaluatee ID",
  evaluatee.stdfname + ' ' + evaluatee.stdlname as "Evaluatee ID",
  evaluator.stdid as "Evaluator ID",
  evaluator.stdfname + ' ' + evaluator.stdlname as "Evaluator ID"
from students evaluatee, students evaluator, evaluations
where evaluatee.stdid = evaluations.evaluateeID
and evaluator.stdid = evaluations.evaluatorID
order by evaluateeID;