Select to_number(sum (case when e_section.certify_date is not null then 1 else 0 end )*100/count(*),99999.99) as prc
The answer suppose to coe like above. Somehow when I ran the select statement, it's indicating an error message: ERROR: function to_number(bigint, numeric) does not exist
However I know e_section and certify_date columns exist.
How do I arrange this function? Can anyone help me plz?