I have a customer that wants to see the Up Status Count, Down Status Count and Total asset Count of his providers displayed in 3 columns.
I have been able to get the basics of up or down but cannot figure out how to use the same column in the same SQL query to get a different output.
See example attached.

____________________
Here is what i have so far"
SELECT Carrier, COUNT(NodeID) AS 'Count Of Up Nodes' FROM [dbo].[Nodes]
WHERE Status = '1'
and
Carrier is not NULL
and
Carrier != 'none'
group by Carrier