Subquery Count Not Grouping

[harishgg1]

hi

thats one way to do it

when you have a large SQL Query

the part where it takes a long time
usually put it into Temp tables # tables with indexes

and then use it in Joins