How many courses are offered?
select count ( course_id ) from course
How many courses have more than one prerequisite?
select count ( * ) from ( select t1.title from course as t1 join prereq as t2 on t1.course_id = t2.course_id group by t2.course_id having count ( * ) > 1 )
Can you tell me the titles of those courses?
select t1.title from course as t1 join prereq as t2 on t1.course_id = t2.course_id group by t2.course_id having count ( * ) > 1
What departments are those courses in?
select t1.dept_name,t1.course_id from course as t1 join prereq as t2 on t1.course_id = t2.course_id group by t2.course_id having count ( * ) > 1
Can you also provide the number of credits for each of those courses?
select t1.credits,t1.course_id from course as t1 join prereq as t2 on t1.course_id = t2.course_id group by t2.course_id having count ( * ) > 1