Question: Please help me solve this. This uses the northwoods database and more specifically the course_section table. 5. Display the number of classes by days, and
Please help me solve this.
This uses the northwoods database and more specifically the course_section table.

5. Display the number of classes by days, and time of the day, formatted as shown below: Days Time Number of classes MTWRF MTWRF MWF MWF MUF MWF MwF TR TR TR TR 08:00 a.m 09:00 a.m 08:00 a.m 09:00 a. m 10:00 a.m 02:00 p.m 03:00 p.m 08:00 a.m 09:30 a. 11:00 a.m 02:00 p.m 2 2 11 rows selected 6. Now replace the day expression with a more meaningful explanation, and order by days Remove leading zeroes from the time, as shown below Days Time Number of classes Every day of the week 9:00 a.m Every day of the week 8:00 a.m. MonWed Fri Mon-Wed Fri MonWed Fri MonWed - Fri MonWed Fri Tues - Thurs Tues - Thurs Tues - Thurs Tues - Thurs 2 3:00 p.m 2:00 p.m 10:00 a.m 9:00 a.m 8:00 a.m 11:00 a.m 9:30 a.m 8:00 a.m 2:00 p .m 2 1 rows selected
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
