Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SQL QUESTION - For each class taught in the business school, list the professor, course name, class section, and total enrollment for that class. CLASS
SQL QUESTION -
For each class taught in the business school, list the professor, course name, class section, and total enrollment for that class.
CLASS EMPLOYEE Table name - PROFESSOR \begin{tabular}{|l|l|l|l|} \hline EMP_NUM & DEPT_CODE & PROF_OFFICE & PROF_EXTENSION \\ \hline 103 & HIST & DRE 156 & 6783 \\ \hline 104 & ENG & DRE 102 & 5561 \\ \hline 105 & ACCT & KLR 229 D & 8665 \\ \hline 106 & MKT/MGT & KLR 126 & 3899 \\ \hline 110 & BIOL & AAK 160 & 3412 \\ \hline 114 & ACCT & KLR 211 & 4436 \\ \hline 155 & MATH & AAK 201 & 4440 \\ \hline 160 & ENG & DRE 102 & 2248 \\ \hline 162 & CIS & KLR 203E & 2359 \\ \hline 191 & MKT/MGT & KLR 409B & 4016 \\ \hline 195 & PSYCH & AAK 297 & 3550 \\ \hline 209 & CIS & KLR 333 & 3421 \\ \hline 228 & CIS & KLR 300 & 3000 \\ \hline 297 & MATH & AAK 194 & 1145 \\ \hline 299 & ECON/FIN & KLR 284 & 2851 \\ \hline 301 & ACCT & KLR 244 & 4683 \\ \hline 335 & ENG & DRE 208 & 2000 \\ \hline 342 & SOC & BBG 208 & 5514 \\ \hline 387 & BIOL & AAK 230 & 8665 \\ \hline 401 & HIST & DRE 156 & 6783 \\ \hline 425 & ECON/FIN & KLR 284 & 2851 \\ \hline 435 & ART & BBG 185 & 2278 \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started