Solution 1:
SELECT c.name, count(m.mailid)
FROM Employee
LEFT JOIN mailingSubscriptions as m ON c.Name = m.EmployeeName
GROUP BY c.name;
MySql Count cannot show 0 values
Solution 1:
SELECT c.name, count(m.mailid)
FROM Employee
LEFT JOIN mailingSubscriptions as m ON c.Name = m.EmployeeName
GROUP BY c.name;