1. SELECT name FROM instructor WHERE dept_name = 'Biology';
2. SELECT title FROM course WHERE dept_name = 'Comp. Sci.' AND credits = 3;
3. SELECT takes.course_id, title FROM takes, course WHERE ID = 76543 AND takes.course_id = course.course_id;
4. SELECT department.* FROM instructor, department WHERE instructor.dept_name = department.dept_name GROUP BY instructor.dept_name HAVING count(instructor.dept_name) > 2;