SQL Question

[AndyCr15]

Hi all, I wonder if someone can help with this -

SELECT
  firstname,
  surname,
  employee.is,
  COUNT(score)
FROM partners
LEFT JOIN scores
  ON employee.id= score.employee_id
WHERE
MONTH = 6
AND YEAR = 2018
GROUP BY score.employee_id
ORDER BY COUNT(score) ASC;

I have an employees table and a scores view, joined by the id & employee_id keys.

When an employee achieves something, they are awarded points (into the scores view). The above code returns how many scores an employee has received in that month, but if they have none, nothing is returned.

I know a LEFT JOIN should return everything in the employee table, but I also realise my WHERE terms mean it will ignore those that haven't received a score that particular month.

How can I get a complete list of the employees returned, with 0 if they haven't scored anything?

Thanks

 

[AndyCr15]

Itchy, I'm fairly sure I was missing some results? I'm not sure why.

Thanks Billy, that worked Much appreciated!