Write SQL queries for questions 1-10 using the following University schema. Classroom(building room number, capacity) Department(dept_name, building, budget) Course(course_id title, dept name, credits) Instructor(i id, name, dept_name, salary) Sectionlcourse id, sec id, semester, vear, building, room number, time slot id) Teachesfi id course_id sec_id semester, year) Students id, name, dept name, tot_cred) Takes(s id, course_id sec id, semester, year, grade) Advisors_id i id) Time slot(time slot id, dav, start hr, start min, end hr, end min) Prereq(course id, prereg id) Grade_points grade, points) 1. (10 points) Find the s ids and names of all students who were taught by arn instructor named 'Katz. Output columns: Name Sort by: Name in ascending order S ID Name