Which courses have more than 1 prerequisite?
select * from course as t1 join prereq as t2 on t1.course_id = t2.course_id group by t2.course_id having count(*) > 1
What title, credit, and department name correspond to these?
select t1.title, t1.credits, t1.dept_name from course as t1 join prereq as t2 on t1.course_id = t2.course_id group by t2.course_id having count(*) > 1