List the names of faculty members and the course number for which the faculty member teaches the same course number as his or her supervisor in 2006. SELECT FacFirstName, FacLastName, O1.CourseNo
List faculty member who have a higher salary than their supervisor. List the Social Security number, name and salary of the faculty and supervisor. SELECT Subr.FacSSN, Subr.FacLastName, Subr.FacSalary,
List name and faculty number of Management Science (MS) or Finance (FIN) full professor. (Note, full professors' FacRank is recorded as PROF.) SELECT FacFirstName, FacLastName, FacNo FROM Faculty WHERE (FacDept = 'MS' OR FacDept = 'FIN') /Correct /
(Note, full professors' FacRank is recorded as PROF.) SELECT FacFirstName, FacLastName, FacNo FROM Faculty WHERE (FacDept = 'MS' OR FacDept = 'FIN') /Correct /