メモ：メモ一覧
更新

select AVG(C.CONR_GOAL_NO) AS AAA from ASB003TB A inner join CSB001TB AA ON AA.HORSE_CD = A.HORSE_CD AND AA.RACE_CD = A.RACE_CD inner join CSB001TB BB ON BB.HORSE_CD = AA.HORSE_CD AND BB.RACE_CD < AA.RACE_CD inner join ASB003TB B ON B.HORSE_CD = BB.HORSE_CD AND B.RACE_CD = BB.RACE_CD inner join ASB012TB C ON C.RACE_CD = B.RACE_CD AND C.HORSE_NUM =B.HORSE_NUM WHERE A.RACE_CD = '20180106011' AND A.HORSE_NUM = '1'