SELECT IIF(BETWEEN(salary,0.00,9999.99),'r1', ;
       IIF(BETWEEN(salary,10000.00,19999.99),'r2', ;
       'r3')) as range, ;
       sex ;
       FROM yourTable ;
       INTO CURSOR Q1

SELECT INT(salary/10000) as range, ;
       sex ;
       FROM yourTable ;
       INTO CURSOR Q1

SELECT UserDefinedFunction(salary) as range, ;
       sex ;
       FROM yourTable ;
       INTO CURSOR Q1

SELECT range, sex, count(*) ;
       FROM Q1 ;
       ORDER BY 2,1 ;
       GROUP BY 2,1 ;
       INTO CURSOR Q2