list all department code and department name
select dept_code, dept_name from department
Sorry, I meant to show me all the course codes where department code is "CIS"
select t2.crs_code from department as t1 join course as t2 on t1.dept_code = t2.dept_code where t1.dept_code = "CIS"
can I get a count of these courses where department code is "CIS"?
select count ( * ) from department as t1 join course as t2 on t1.dept_code = t2.dept_code where t1.dept_code = "CIS"