Hi Luis,

How are you? Since long time keeping your foot print on my post. Appreciate your time on this. Some time mind doesn't work to write easy logic.

this is how i implemented.

selectsum(case when score >= 0 and score < 40 then Items end) as poor,

sum(case when score >= 40 and score < 70 then Items end) as average,

sum(case when score >= 70 then Items end) as Good

fromsample

Thanks for your precious time on this post.