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 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
Get step-by-step solutions from verified subject matter experts
