What can you tell me about the Computer Info. Systems department?
select * from department where dept_name = "Computer info. Systems"
What courses does it offer?
select * from department as t1 join course as t2 on t1.dept_code = t2.dept_code where dept_name = "Computer info. Systems"
How many courses is that?
select count(*) from department as t1 join course as t2 on t1.dept_code = t2.dept_code where dept_name = "Computer info. Systems"