Consider the following two tables and select the MOST accurate statement about them: What will be the output of the following query:$-$ SELECT CName, COUNT$($S$.$SID$)$ AS Enrolled$\_$Students FROM Course C LEFT JOIN Student S ON S$.$CourseID $=$ C$.$CID GROUP BY CName HAVING COUNT$($S$.$SID$)4$ None of the choices. The query will provide a list of all courses which have $4$ or less than $4$ students enrolled. The query will result in an error. The query will provide a list of all students who are enrolled in $4$ or less than $4$ courses. The query will provide a list of all courses which have only $4$ students enrolled.