Assume you have been asked to write and execute a query to retrieve the list of ALL departments and the number of sections offered in a university semester for each department. If a department has not offered any section this semester, the department should appear in the list with the number $0.$

For each of the following SQL statements, state "Yes" if it retrieves the information requested and $"$No$"$ if otherwise.

$1.$ SELECT DCode,DName, COUNT$($s$.$SectId$)$ as Sections FROM Department d JOIN Course c on d$.$DCode $=$ c$.$Department

JOIN Section s on c$.$CoCode $=$ s$.$Course WHERE s$.$Semester $=\text{'}1248\text{'}$ OR s$.$Semester is NULL

GROUP BY DCode;

$2.$ SELECT DCode,DName, COUNT$($s$.$SectId$)$ as Sections FROM Department d LEFT JOIN Course c on d$.$DCode $=$ c$.$Department

LEFT JOIN Section s on c$.$CoCode $=$ s$.$Course WHERE s$.$Semester $=\text{'}1248\text{'}$ OR s$.$Semester is NULL

GROUP BY DCode;

$3.$ SELECT DCode,DName, COUNT$($s$.$SectId$)$ as Sections FROM Department d LEFT JOIN Course c on d$.$DCode $=$ c$.$Department

LEFT JOIN Section s on c$.$CoCode $=$ s$.$Course WHERE s$.$Semester $=\text{'}1248\text{'}$

GROUP BY DCode;