zOs/SQL/CIAMIRCO

select count(*), c from
(
SELECT  case
     when FI02701A < 3200000                              then '<<<  '
     when FI02701A > 4500000                              then '>>>  '
     when FI02701A = 3200000 and FI02704A <= '31.12.2010' then '<=240'
     when FI02701A = 4500000 and FI02704A  > '31.01.2000' then '>=242'
     when                        FI02704A <= '31.01.2000' then '241 <='
     else                                                      '241 >'
     end c, t.*
  FROM F383353.TFI027A1 T
) c
  WHERE FI02701A BETWEEN 3000000 AND 4700000
  group by c
  WITH UR;
;x;
SELECT COUNT(*)
  FROM F383353.TFI027A1 T
  WHERE FI02701A BETWEEN 3200001 AND 4500000 AND FI02704A<='31.01.2000'
  WITH UR;