Help Please

CIST 1220: SQL-Assign #9 (40 Points) [Simple Joins - Chap 9] Using the database provided, Write and Execute SELECT statements to get the following information: (Joins are difficult, make sure to Read Chap 7 and check out some examples before you begin this exercise!!!!) SIMPLE JOINS Sections Table 1.) What is the name of the Instructor teaching Section 30101? (List all Section information, plus the Instructor's first and last name) 2.) What is the name of the course for Section 30108? (List all Section information, plus the course name) 3.) Give a list of all course names that instructor 6 is teaching. (List course name, CRN, TimeDays, roomNo and instructor ID) Does instructor 6 have a scheduling conflict? 4.) How many total credit hours is instructor 6 teaching? 5.) Please give the CRN. Course Name, description and credithours, timedays and roomno for all the courses being taught in room F1149. Are there any conflicts? StudentSchedule Table 6.) Give a list of Student Names and IDs that are signed up for the section with CRN=30101. (List Student's first name, last name, D and CRN) 7.) Please list all the student names(first and last) that are in the section with CRN=301 15. 8.) Please list all section information for all the sections that are being attended by Student with id=6. 9.) Please list all section information for all the sections that are being attended each student. 10.) Advanced(Multiple tables): Please list the name of the course, the CRN and the Names of all the students that are in the section with CRN=30115