SELECT clender_loan_number,; PADR(ICASE(nborrower_number_of_employees >= 0 .and. nborrower_number_of_employees <= 9 , "0 - 9",; nborrower_number_of_employees >= 10 .and. nborrower_number_of_employees <= 24, "10 - 24",; nborrower_number_of_employees >= 25 .and. nborrower_number_of_employees <= 49, "25 - 49",; nborrower_number_of_employees >= 50 .and. nborrower_number_of_employees <= 99, "50 - 99",; nborrower_number_of_employees >= 100 .and. nborrower_number_of_employees <= 249, "100 - 249",; nborrower_number_of_employees >= 250 , "250 "),10) as cRange ,; ICASE(nborrower_number_of_employees >= 0 .and. nborrower_number_of_employees <= 9 , 1,; nborrower_number_of_employees >= 10 .and. nborrower_number_of_employees <= 24, 2,; nborrower_number_of_employees >= 25 .and. nborrower_number_of_employees <= 49, 3,; nborrower_number_of_employees >= 50 .and. nborrower_number_of_employees <= 99, 4,; nborrower_number_of_employees >= 100 .and. nborrower_number_of_employees <= 249, 5,; nborrower_number_of_employees >= 250 , 6) as nPrint_Order FROM loan