The following T-SQL statements are run on enterpriseDB database:

MS SQL: enterpriseDB, GROUP BY image

uamMembers with MemberPaid as 1 implies that the member payment is complete. We want to find number of paid users for each uamGroup. (If a uamGroup does not have any paid members, we want to have 0 as paid members count). Of the following T-SQL statements, what should we run to achieve this?

MS SQL: enterpriseDB, GROUP BY image