Statement: seasons 2001 - 02 , 2002 - 03 and 2003 - 04 were in the limited format
Input Table: tsuyoshi fujita
season | event_type | location | format | date | rank |
1997 - 98 | nationals | tokyo | special | 1998-07-04 | 4 |
1998 - 99 | grand prix | kyoto | limited | 1999-01-16 | 4 |
1998 - 99 | apac region championship | singapore | special | 1999-03-27 | 3 |
1999 - 00 | grand prix | taipei | extended | 2000-02-12 | 2 |
2000 - 01 | grand prix | kyoto | extended | 2000-11-12 | 1 |
2000 - 01 | grand prix | hiroshima | limited | 2001-01-27 | 6 |
2000 - 01 | pro tour | tokyo | block constructed | 2001-03-16 | 2 |
2001 - 02 | grand prix | hong kong | limited | 2001-11-17 | 3 |
2001 - 02 | masters | san diego | standard | 2002-01-11 | 7 |
2001 - 02 | grand prix | fukuoka | limited | 2002-02-16 | 6 |
2001 - 02 | grand prix | nagoya | team limited | 2002-05-11 | 4 |
2002 - 03 | grand prix | utsunomiya | limited | 2002-10-12 | 3 |
2002 - 03 | grand prix | hiroshima | extended | 2003-01-25 | 7 |
2002 - 03 | grand prix | bangkok | standard | 2003-07-12 | 1 |
2003 - 04 | nationals | osaka | special | 2004-06-11 | 1 |
2003 - 04 | grand prix | kuala lumpur | standard | 2004-07-24 | 4 |
2005 | grand prix | seattle | extended | 2005-03-05 | 7 |
2005 | invitational | los angeles | special | 2005-05-17 | 2 |
2005 | pro tour | london | booster draft | 2005-07-08 | 2 |
2005 | pro tour | los angeles | extended | 2005-10-28 | 5 |
2011 | pro tour | nagoya | block constructed and booster draft | 2011-06-10 | 5 |
SQL Command:
SELECT
CASE
WHEN (SELECT COUNT(*) FROM table_sql WHERE format = 'limited' AND season IN ('2001 - 02', '2002 - 03', '2003 - 04')) = 3
THEN 'TRUE'
ELSE 'FALSE'
END;