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"
showing all course codes where department code is 'CIS' involves selecting crs_code from a table named course that is joined with a department table on dept_code, and specifically filtering for dept_code = 'CIS';