select faculty name where he takes same course as his supervisor

by Miss Rosemary Runolfsson 4 min read

How do I list faculty members with the same course number?

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

How do I list faculty members with higher salaries than Supervisors?

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,

How do I find the faculty number of management science/finance professors?

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 /

How do I find the facrank of a full professor?

(Note, full professors' FacRank is recorded as PROF.) SELECT FacFirstName, FacLastName, FacNo FROM Faculty WHERE (FacDept = 'MS' OR FacDept = 'FIN') /Correct /