SELECT SUBSTR(tbt1.writng_de, 1, 4) years , COUNT(*) cnt , COUNT(CASE WHEN eiid.etc_input_iem >= 3 THEN 1 END) overs FROM tn_bbs_ty1 tbt1 , tn_bbs_etc_iem_input_data eiid WHERE tbt1.bbs_no = eiid.bbs_no AND tbt1.ntt_no = eiid.ntt_no AND tbt1.bbs_no = 54 AND eiid.etc_iem_no = 1 GROUP BY SUBSTR(tbt1.writng_de, 1, 4) ORDER BY years DESC ;