Find the names of all instructors in the Art department who have taught some course and the course id.
select t1.name, t2.course_id from instructor as t1 join teaches as t2 on t1.id = t2.id where t1.dept_name = 'Art'
Find the names of all instructors in the Art department
select name from instructor where dept_name = 'Art'
Find the instructor id of all instructors in the Statistics department
select id from instructor where dept_name = 'Statistics'