(Solved): tudentSchedule Table 6.) Give a list of Student Names and IDs that are signed u ...

tudentSchedule Table 6.) Give a list of Student Names and IDs that are signed up for the section with $$\mathrm{CRN}=30101$$. (List Student's first name, last name, ID and $$\mathrm{CRN}$$ ) 7.) Please list all the student names(first and last) that are in the section with $$\mathrm{CRN}=30115$$. 8.) Please list all section information for all the sections that are being attended by Student with $$\mathrm{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 $$\mathrm{CRN}=30115$$. \begin{tabular}{|l|l|l|l|r|} \hline \multicolumn{3}{|c|}{ Sections } \\ \hline CRN & CourselD & \multicolumn{1}{|c|}{ TimeDays } & RoomNo & Instructor \\ \hline 30101 & CIST 2341 & MW1-5pm & F1145 & 1 \\ \hline 30102 & CIST 2371 & MW6-10pm & F1145 & 3 \\ \hline 30103 & CIST 1130 & TTH6-9pm & F1145 & 2 \\ \hline 30104 & CIST 1001 & TTH6-9pm & F1144 & 5 \\ \hline 30105 & CIST 1130 & MW6-9pm & F1144 & 2 \\ \hline 30106 & CIST 1130 & MW8-11am & F1144 & 2 \\ \hline 30108 & CIST 1510 & MW1-5pm & F1149 & 6 \\ \hline 30109 & CIST 2371 & TTH1-5pm & F1147 & 3 \\ \hline 30110 & CIST 2341 & S8am-2pm & F1147 & 3 \\ \hline 30111 & CIST 2371 & TTH1-5pm & F1147 & 1 \\ \hline 30112 & CIST 2372 & MW1-5pm & F1150 & 1 \\ \hline 30113 & CIST 1001 & MW10am-12pm & F1150 & 4 \\ \hline 30114 & CIST 1001 & S8am-12pm & F1150 & 4 \\ \hline 30115 & CIST 1305 & MW10am-12pm & F1148 & 5 \\ \hline 30116 & CIST 1220 & MW1-5pm & F1148 & 6 \\ \hline 31107 & CIST 1510 & TTH1-5pm & F1149 & 6 \\ \hline \end{tabular} 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!!!!)