More than 1 year has passed since last update.

jra公式データから3連複の払戻金の2010年から2021年の金額統計

SQL
SQLite
競馬

Posted at 2021-12-29

SELECT
	min(N_HARAI.PaySanrenpukuPay1)*1,
	avg(N_HARAI.PaySanrenpukuPay1)*1,
	max(N_HARAI.PaySanrenpukuPay1)*1
FROM
	N_RACE
INNER JOIN
	N_HARAI
		ON
			N_HARAI.Year = N_RACE.Year
				AND
			N_HARAI.MonthDay = N_RACE.MonthDay
				AND
			N_HARAI.JyoCD = N_RACE.JyoCD
				AND
			N_HARAI.RaceNum = N_RACE.RaceNum
WHERE
	N_RACE.JyoCD IN("01", "02", "03", "04", "05", "06", "07", "08", "09", "10")
		AND
	N_RACE.Year IN("2010", "2011", "2012", "2013", "2014", "2015", "2016", "2017", "2018", "2019", "2020", "2021")
		AND
	N_RACE.TorokuTosu = "18"

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up