Here is how to count bit in SQL
<pre><code>SELECT Id, count(1) as TotalCount, 
SUM(CASE WHEN Addressed = 1 THEN 1 ELSE 0 END) as AddressedCount 
FROM [dbo].[Alerts]
</code></pre>

Here is how to count bit in SQL

```
SELECT Id, count(1) as TotalCount, 
SUM(CASE WHEN Addressed = 1 THEN 1 ELSE 0 END) as AddressedCount 
FROM [dbo].[Alerts]
``` 


Counting Bit (true & false) in SQL