sql server counts of columns

Question

 Hi,

 

 

select count(*) from table1 where inventoryid = 21 -- 132

select count([expired]) from table1 where inventoryid = 21 and [expired] = 1 -- 57

select count([Consigmment]) from table1 where inventoryid = 21 and [expired] = 1 -- 54

· I need the results as in below screenshot - with a single query

 

InventoryId	Counts	Expired	Consigmnet
21	132	57	54

 

 

Regards,

hari