select (case when Is_Sale = 'I' then '1' when Is_Sale = 'C' then '2' when Is_Sale = 'J' then '3' when Is_Sale = 'E' then '4' end) as CC,* from tb_Car where Is_open='Y' AND Is_Sale <>'E' and Category1='4300' ORDER BY CC,sn desc