Statement: the first record was recorded in november of the year 1965
Input Table: list of sumo record holders
name | total | first | last | highest_rank |
kotonishiki | 34 | 1990-09-01 | 1999-09-01 | sekiwake |
kaiō | 32 | 1994-05-01 | 2000-07-01 | ōzeki |
musōyama | 31 | 1994-03-01 | 2000-09-01 | ōzeki |
hasegawa | 30 | 1965-11-01 | 1974-09-01 | sekiwake |
kotomitsuki | 30 | 2001-01-01 | 2007-07-01 | ōzeki |
akinoshima | 27 | 1988-11-01 | 2000-09-01 | sekiwake |
takamiyama | 27 | 1969-11-01 | 1982-09-01 | sekiwake |
takatōriki | 26 | 1991-05-01 | 2000-05-01 | sekiwake |
wakanosato | 26 | 2000-11-01 | 2005-09-01 | sekiwake |
daikirin | 22 | 1966-11-01 | 1970-09-01 | ōzeki |
tochiazuma ii | 22 | 1997-07-01 | 2005-01-01 | ōzeki |
kisenosato | 22 | 2006-07-01 | 2011-09-01 | ōzeki |
SQL Command:
SELECT
CASE
WHEN COUNT(*) = 0 THEN 'FALSE'
ELSE 'TRUE'
END
FROM table_sql
WHERE first LIKE '%-11-%'
AND first LIKE '1965-%';