Question: *MySQL* Please. Not sure what I am doing wrong. The enrollment team is gathering analytics about student enrollment and they now want to know about

*MySQL* Please. Not sure what I am doing wrong. The enrollment team*MySQL* Please. Not sure what I am doing wrong.

is gathering analytics about student enrollment and they now want to knowabout August admissions specifically. Write a query that lists the Start Date

The enrollment team is gathering analytics about student enrollment and they now want to know about August admissions specifically. Write a query that lists the Start Date and Total Number of Students who enrolled in classes in August of each year. The output should be ordered first by Start Date in ascending order and then by Total Number of Students in ascending order. College Management System Schema Language: MySQL (i) \( \begin{array}{ll}1 & \text { SELECT COUNT(studentId) AS "Students", DATE_FORMAT(startDate, } \% Y-\% \mathrm{~m}^{1} \text { ) } \text { AS }^{\text {"Year-Aug" }} \\ 2 & \text { FROM studentCourse WHERE DATE_FORMAT(startDate, } 1 \% \mathrm{~m}^{\prime} \text { ) LIKE } \% 08 \% 1 \\ 3 & \text { GROUP BY startDate } \\ 4 & \text { ORDER BY startDate ASC, COUNT (studentId) ASC; }\end{array} \) Test Results Incorrect answer. Test case 0 B Your Output (stdout) \begin{tabular}{l|cc} 1 & 52 & 201408 \\ 2 & 114 & 201508 \\ 3 & 145 & 201608 \\ 4 & 317 & 201708 \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!