MySQL table join with COUNT column – where to place AND condition for count?

I have 2 tables
Table_1:

Table_2:

This MySQL query produces the result I expect:

Result:

But I need a condition for the count:

I want to produce the result:

But I do not know where to place my "AND" statement.
When I place it with the join:

Not all rows are returned from Table_1 – yet the My_Count will be accurate.
I need all of the rows from Table_1
How do I place my 'AND' Statement so that my query will return all of the rows from Table_1 with the accurate count column?


View on Stack Overflow