Plan-of-SQLs (Ours)

Statement: 25 - 26 january 2003 and 12 - 13 july 2003 were the only games played in 2003

Ground-truth: TRUE

Input Table: tsuyoshi fujita

Step 1: Select rows where the 'date' column is between '2003-01-25' and '2003-07-13'.
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
Step 2: Use a `CASE` statement to return TRUE if the number of rows is equal to 2, otherwise return FALSE.
season event_type location format date rank
2002 - 03 grand prix hiroshima extended 2003-01-25 7
2002 - 03 grand prix bangkok standard 2003-07-12 1
Final output table:
verification_result
TRUE

Prediction: TRUE

Ground-truth: TRUE