select to_char(hiredate, 'yyyy') || to_char(num, '-FM0000') as 識別番号, name as 名前, to_char(ng, '999,999') as 失敗回数, to_char(ok, '999,999') as 成功回数, to_char(ok::float / (ok + ng), '0.9999') as 成功率 from t03_2 ;