Using the IN keyword, list all course titles that are taught by Mozart and Srinivasan.

Hint: you need the date from three tables: instructor, teaches, course. Expect 4 rows.

# 5. Using the IN keyword, list all course titles that are taught by Mozart and Srinivasan. # Hint: you need the data from three tables: instructor, teaches, course. Expect 4 rows. # example: total number of distinct students who have taken course sections taught by instructor with ID 10101 select count(distinct ID) from takes where (course_id, sec_id, semester, year) in (select course_id, sec_id, semester, year from teaches where teaches. ID 10101); 10 select * from instructor; 26:10 1 error found 100% Result Grid ut Filter Rows: a Sonrch ID name dept_name salary 10101 Srinivasan Comp. Sci. 65000.00 12121 Wu Finance 90000.00 15151 Mozart Music 40000.00 22222 Einstein Physics 95000.00 32343 El Said History 60000.00 33456 Gold Physics 87000.00 45565 Katz Comp. Sci. 75000.00 58583 Califieri History 62000.00 76543 Singh Finance 80000.00 76766 Crick Biology 72000.00 83821 Brandt Comp. Sci. 92000.00 98345 |Kim Elec. Eng. 80000.00 NULL NULL NULL NULL 100% select * from teaches: 23:11 1 error found Result Grid Hut Filter Rows: a Search ID course_id sec_id semester year - 76766 BIO-101 1 Summer 2009 76766 BIO-301 1 Summer 2010 10101 CS-101 1 Fall 2009 45565 CS-101 1 Spring 2010 83821 CS-190 1 Spring 2009 83821 CS-190 2 Spring 2009 10101 CS-315 1 Spring 2010 45565 CS-319 1 Spring 2010 83821 CS-319 2 Spring 2010 10101 CS-347 1 Fall 2009 98345 EE-181 1 Spring 2009 12121 FIN-201 1 Spring 2010 32343 HIS-351 1 Spring 2010 15151 MU-199 1 Spring 2010 22222 PHY-101 11 Fall 2009 NULL NULL NULL NULL NULL 12 00% select * from course: 22:12 1 error found Result Grid HI Filter Rows: a Search Edit: course_id title dept_name credits BIO-101 Intro. to Biology Biology 4 BIO-301 Genetics Biology 4 BIO-399 Computational Biology Biology 3 CS-101 Intro. to Computer Science Comp. Sci. 4 CS-190 Game Design Comp. Sci. 4 CS-315 Robotics Comp. Sci. 3 CS-319 Image Processing Comp. Sci. 3 CS-347 Database System Concepts Comp. Sci. 3 EE-181 Intro. to Digital Systems Elec. Eng. 3 FIN-201 Investment Banking Finance 3 HIS-351 World History History 3 MU-199 Music Video Production Music 3 PHY-101 Physical Principles Physics 4