There are relations: student sid, name, address, status, advisorlD) advisorD is profD transcript sid.cno. semester, grade) course(cno, deptlD, cName, credits) teaching(proflD, cno.semester) professor(profIlD, name, deptID) Please write SQL query to answer the following requests. You can use aggregate functions, if needed. (1) List the cno and cname of the courses taught during "S2002 and F2002 semesters. (2) List the cno of the courses that have been taught by CS professors. (3) List the cno of the courses that have never been taught by profess James Lee. (3) Find the names of the professors who taught at least two courses in the same semester (4) List the names of the professors who taught every course offered in SE'department (5) List the names of the students who have John Brown' as their advisor. (Queries below are expected to use aagregate functions. Work on them after Wednesday's class.) 6) Lis each professor's name and the rumber of studtents they have advised. 71 List the course name of the courses that have been taught mos times (B) Find the students who took more than 16 credit hours courses in some