SQL : Query with left join and count in select works in MySQL but not in MS SQL Server 2012

SQL : Query with left join and count in select works in MySQL but not in MS SQL Server 2012
To Access My Live Chat Page,
On Google, Search for “hows tech developer connect”

Here’s a secret feature that I promised to disclose to you.
This is a YouTube’s feature which works on Desktop.
First, Ensure that the video is playing before proceeding.
After that, type the word ‘awesome’ on your keyboard.
Your YouTube progress bar will transform into a flashing rainbow.

A little intro about me,
Greetings, my name is Delphi.
Allow me to support you in answering your questions.
SQL : Query with left join and count in select works in MySQL but not in MS SQL Server 2012
If you have a more detailed question, feel free to comment or chat with me to let me know.
If you have knowledge to contribute or an answer to provide, we encourage you to comment below.
Your answer will be recognized and appreciated with a ‘heart’ from me.
join Query count Server with in SQL : left MySQL 2012 MS and select in SQL in not works but