In the subquery below how can I build it to filter on account manager.

Current:
The main query below works well. It provides Counts by names as needed.
There has been a subquery added in the select statement which provides a single count value. I don't use the Full_Name column.

Problem:
The TotalCount column is just a total and does not breakout the individual values by name I would like the subquery count, TotalCount, to filter on names so each name has an individual count as in the main query. Can this be done or is there a better way?

"...Problem:
The TotalCount column is just a total and does not breakout the individual values by name ..."

You may want to build a new function that returns name beside total - maybe you need to pass in two parameters not just o.quote_Number then do the GROUP BY later in the statement.
...
TotalCount=(SELECT Count(o.quote_Number) FROM SnivalTest_ED..Opportunity o)
...