Use joins instead of sub-queries (#12713).
Sub-queries in group by are not supported by SQLServer.
Authored by: jplang 2013-01-03
Parent: [r11106]
Child: [r11108]