Which Transact-SQL statement should you run?

exams 70-761 70-761 exam 0 Comments

You have a database named My Db. You run the following Transact-SQL statements:

A value of 1 in the IsActive column indicates that a user is active.

You need to create a count for active users in each role. If a role has no active users. You must display a zero as the active users count.

Which Transact-SQL statement should you run?
A .