q$1.$ Find the course$\_$id$,$ sec$\_$id$,$ semester, building, day, start$\_$hr and start$\_$min for all courses that ran in $2010.$

q$2.$ List the Course$-$id$,$ building, room number and room capacity assigned to a course for all sections that ran in $2010.$ Note that schema abbreviated room$\_$number to room$\_$no$.$ Use room$\_$number

q$3.$ Find the names of all advisors for students in the Comp. Sci. department

q$4.$ List the names of instructors along with the course ID of the courses that they taught.