A. select a, b from table group by a B. select b from table cluster by a C. select a from (select a from t1 union all select a from t2) D. select a from table sort by a distribute by b