How many courses does the Computer Info. Systems department offer?
select count ( * ) from department as t1 join course as t2 on t1.dept_code = t2.dept_code where dept_name = "Computer info. Systems"
What are the descriptions of those courses?
select crs_description from department as t1 join course as t2 on t1.dept_code = t2.dept_code where dept_name = "Computer info. Systems"
How many courses does the Biology department offer?
select count ( * ) from department as t1 join course as t2 on t1.dept_code = t2.dept_code where dept_name = "Biology"
What about the Accounting department?
select count ( * ) from department as t1 join course as t2 on t1.dept_code = t2.dept_code where dept_name = "Accounting"
What are the course credits of those courses?
select t2.crs_credit from department as t1 join course as t2 on t1.dept_code = t2.dept_code where dept_name = "Accounting"