select t.range as score_range, count(*) as number
from (
  select case
    when preis between 1 and 2 and haendler = 'sammler' and bezeichnung like '%tung%' then ' 1-2'
    when preis between 3 and 4 and haendler = 'sammler' and bezeichnung like '%tung%' then ' 3-4'
    when preis between 5 and 6 and haendler = 'sammler' and bezeichnung like '%tung%' then ' 5-6'
    when preis between 7 and 8 and haendler = 'sammler' and bezeichnung like '%tung%' then ' 7-8'
    when preis between 9 and 10 and haendler = 'sammler' and bezeichnung like '%tung%' then ' 9-10'
    when preis between 11 and 12 and haendler = 'sammler' and bezeichnung like '%tung%' then '11-12'
    when preis between 13 and 14 and haendler = 'sammler' and bezeichnung like '%tung%' then '13-14'
    when preis between 15 and 16 and haendler = 'sammler' and bezeichnung like '%tung%' then '15-16'
    when preis between 17 and 18 and haendler = 'sammler' and bezeichnung like '%tung%' then '17-18'
    when preis between 19 and 20 and haendler = 'sammler' and bezeichnung like '%tung%' then '19-20'
    when preis between 21 and 22 and haendler = 'sammler' and bezeichnung like '%tung%' then '21-22'
    end as range
  from produkt) t

group by t.range
order by score_range