Which courses have a description including the word "Statistics"?
select * from course where crs_description like '%statistics%'
What is the name of the departments those courses are in?
select t2.dept_name from course as t1 join department as t2 on t1.dept_code = t2.dept_code where t1.crs_description like '%statistics%'