メモ：メモ一覧
更新

SELECT COUNT(*) AS CNT ,SUM( CASE WHEN AA.RACE_CD IS NOT NULL THEN 1 ELSE 0 END ) AS PLUS ,SUM( CASE WHEN AA.RACE_CD IS NOT NULL THEN 0 ELSE 1 END ) AS MINA ,SUM( CASE WHEN AA.RACE_CD IS NOT NULL THEN B.ODDS_MIN ELSE -1 END ) AS ODD ,MAX(A.RACE_YMD) AS MAX ,MIN(A.RACE_YMD) AS MIN FROM ASB003TB A INNER JOIN ASB031TB B ON B.RACE_CD = A.RACE_CD AND B.REMON_KBN = '1' AND B.HORSE_NUM_REN = A.HORSE_NUM INNER JOIN ASB021TB C ON C.RACE_CD = A.RACE_CD AND C.REMON_KBN = '1' LEFT JOIN ASB003TB AA ON AA.RACE_CD = A.RACE_CD AND AA.HORSE_NUM = A.HORSE_NUM AND AA.GOAL_NO = '1' WHERE A.POP_NO = '1' AND B.ODDS_MIN >= 1 // 全てのオッズがあるレースコード RACE_CD = 'pw01sde1001200401010920040814/8E'