Instructions:Put your SQL in the "Problem 6"

Instructions:

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.



honeyd


12-09-20 | 16: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 from course c, enrollment e, faculty f, offering o, student s where c.idcourse=o.Course_idCourse and f.idFaculty=o.Faculty_idFaculty and s.idstudent=e.Student_idStudent and o.idOffering=e.Offering_idOffering order by course asc, student_name asc;

Login to answer this question!

A PHP Error was encountered

Severity: Core Warning

Message: PHP Startup: Unable to load dynamic library 'imagick.so' (tried: /opt/cpanel/ea-php73/root/usr/lib64/php/modules/imagick.so (libMagickWand.so.5: cannot open shared object file: No such file or directory), /opt/cpanel/ea-php73/root/usr/lib64/php/modules/imagick.so.so (/opt/cpanel/ea-php73/root/usr/lib64/php/modules/imagick.so.so: cannot open shared object file: No such file or directory))

Filename: Unknown

Line Number: 0

Backtrace: