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
What is the title, credit value, and department name for courses with more than one prerequisite?
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
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 ( * ) > value
What is the title , credit value , and department name for courses with more than one prerequisite ?