Statement: there are only three highest ranks listed in the table
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(DISTINCT highest_rank) = 3 THEN 'TRUE'
ELSE 'FALSE'
END
FROM table_sql;