How many credits does each course have?
select crs_credit, crs_code from course group by crs_code
How many does CIS-220 have?
select crs_credit from course where crs_code = 'CIS-220'
What is its description?
select crs_description from course where crs_code = 'CIS-220'