How many different courses are there?
select count ( distinct crs_code ) from course
How many departments are there?
select count ( dept_code ) from department
yes.
select crs_code from course where crs_description = 'Statistics'
Can you show me a list of all the course descriptions?
select crs_description from course
Can you tell me the course code for the class with the Intro. to Statistics description?
select crs_code from course where crs_description = 'Intro. to Statistics'
yes.
select t2.dept_name from course as t1 join department as t2 on t1.dept_code = t2.dept_code where t1.crs_description = 'Intro. to Statistics'