For each of the information requests below, write an SQL query that provides the requested information.

a. The professor ID, professor name, course ID, and section ID for all course sections taught in the Fall term, sorted by professor name and course ID.

b. The student ID, name, top-ranked area of study, and average grade in the Winter term for all students with an average grade of at least 3.0 in the Winter term.

c. The student ID and name of any student who is not registered in any course section in the Fall term. Use a sub-query in your solution.

studentArea ostudentld rank area depth student studentid stuName birthdate program feesOwed course courseld title credits hours register 00 offering student!d courseld sectid approval grade 00 ?course!d sectid term limit location | y, counsel teach instruction sectid ? type course!d- sectid 0 type description of roomld time profid profName phone officeRoomld deptid room O0 ? roomid- department purpose capacity deptld deptName dcpProfld