[Solved] a query in sql server [closed]

by


I think this is what you are looking for, but as others have commented, it would be much easier if you posted what you have tried so far. 

Select User_ID, Seller_ID
, count(case when action_type = 0 then action_type end) as Type0
, count(case when action_type = 1 then action_type end) as Type1
[...]
from Table
group by User_ID, Seller_ID

2

solved a query in sql server [closed]