What is all the information about the Statistics courses?
select * from course where dept_name = 'Statistics'
What are the names of students who have taken courses in the Statistics department?
select t3.name from course as t1 join takes as t2 on t1.course_id = t2.course_id join student as t3 on t2.id = t3.id where t1.dept_name = 'Statistics'