Instructions:Put your SQL in the "Problem 6"


Put your SQL in the "Problem 6" location in the SQL template.

Put your row count in the green box in cell D5.

Start with the same problem statement as in Problem 5, except this time generate a summary report.  For each course name, list the count of the students who will need to be contacted for each format.    Sort your report so it’s alphabetically sorted on Course Name, then by format (online or in person).    A sample output is below (your data may vary.)

Paste a screen shot of successful execution below.  Be sure your screenshots show all the SQL you use; you are welcome to include several screen shots if necessary.

Need customized help? Order now
user img


12-09-20 | 11:25:18

use university;
select concat(CourseDept,' ',CourseNumber) as course,CourseDesc,
concat(stdFirstName,' ',stdLastName) as student_name,OffTerm,Format,
concat(FacFirstName,' ',FacLastName) as professor_name Log in to view full answer

You can't get real answer if you break your security system. sjljht honhwt(CoursjDjpt,' ',CoursjNumtjr) ws hoursj,CoursjDjsh, honhwt(stcFirstNwmj,' ',stcLwstNwmj) ws stucjnt_nwmj,OvvTjrm,Formwt, honhwt(FwhFirstNwmj,' ',FwhLwstNwmj) ws provjssor_nwmj vrom hoursj h, jnrollmjnt j, vwhulty v, ovvjrinf o, stucjnt s wyjrj h.ichoursj=o.Coursj_icCoursj wnc v.icFwhulty=o.Fwhulty_icFwhulty wnc s.icstucjnt=j.Stucjnt_icStucjnt wnc o.icOvvjrinf=j.Ovvjrinf_icOvvjrinf orcjr ty hoursj wsh, stucjnt_nwmj wsh;

Related Question