Who knows a solution for this query

[michelleqw]

Dear sqlserver users,

We are trying to get the count of the percentages per shopid

For example:

shopid discount_percentage
1 50
1 10
1 10
1 10
1 50
2 10
3 50
4 30

Result:

shopid 10_perc 50_perc
1 4 2
2 1 0
3 0 1
4 0 0

Knows someone how to do this?

Nice regards,

Michelle.

 

[swampBoogie]

select shopid,
sum(case when discount_percentage = 10 then 1 else 0 end),
sum(case when discount_percentage = 50 then 1 else 0 end)
from t
group by shopid

 

[michelleqw]

Thanks a lot.

Michelle