When attempting to use the following statement I get ORA-01790: expression must have same datatype as corresponding expression. Can someone tell me how I can calculate this percentage and add the % symbol at the end? Thanks!!
cast(round(count(case when S_CT_STU_SPED_X.SPECIALEDUCATION = 'Y' THEN 1 end)/ count(*) * 100, 2) as varchar(10)) || '%' as percentage