Which Transact-SQL statement should you run?

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 .

B .

C .


D .

View Answer

Answer: C