select count(*), max(v_double) as max_v_double, min(v_double), v_int, v_float from /test/basic2 group by v_int having v_float>1 /** output() **/ ; select count(*),max(v_double) as max_v_double, min(v_double), v_int from /test/basic group by v_int /** output() **/ ;