Plan-of-SQLs (Ours)


Statement: 2010 - 11 details season has a runner - up of tokai , and a title of 47th

Ground-truth: FALSE

Input Table: all - japan university rugby championship

Step 1: Select rows where 'season' is '2010-11'.
title season winner score runner___up venue attendance
30th 1993-04-01 meiji 41 - 12 hosei national stadium , tokyo , tokyo n / a
31st 1994-05-01 daito bunka university 22 - 17 meiji national stadium , tokyo , tokyo n / a
32nd 1995-06-01 meiji 43 - 9 waseda national stadium , tokyo , tokyo n / a
33rd 1996-07-01 meiji 32 - 22 waseda national stadium , tokyo , tokyo n / a
34th 1997-08-01 kanto gakuin university 30 - 17 meiji national stadium , tokyo , tokyo n / a
35th 1998-09-01 kanto gakuin university 47 - 28 meiji national stadium , tokyo , tokyo n / a
36th 9999-01-01 keio 42 - 15 kanto gakuin university national stadium , tokyo , tokyo n / a
37th 2000-01-01 kanto gakuin university 42 - 15 hosei national stadium , tokyo , tokyo n / a
38th 2001-02-01 kanto gakuin university 21 - 16 waseda national stadium , tokyo , tokyo n / a
39th 2002-03-01 waseda 27 - 22 kanto gakuin university national stadium , tokyo , tokyo n / a
40th 2003-04-01 kanto gakuin university 33 - 7 waseda national stadium , tokyo , tokyo n / a
41st 2004-05-01 waseda 31 - 19 kanto gakuin university national stadium , tokyo , tokyo 35462
42nd 2005-06-01 waseda 41 - 5 kanto gakuin university national stadium , tokyo , tokyo 30163
43rd 2006-07-01 kanto gakuin university 33 - 26 waseda national stadium , tokyo , tokyo 31954
44th 2007-08-01 waseda 26 - 6 keio national stadium , tokyo , tokyo 23694
45th 2008-09-01 waseda 20 - 10 teikyo national stadium , tokyo , tokyo 22344
46th 2009-10-01 teikyo 14 - 13 tokai national stadium , tokyo , tokyo 17569
47th 2010-11-01 teikyo 17 - 14 waseda national stadium , tokyo , tokyo 25458
48th 2011-12-01 teikyo 15 - 12 tenri national stadium , tokyo , tokyo 14407
49th 9999-01-01 teikyo 39 - 22 tsukuba national stadium , tokyo , tokyo 20050

Step 2: Select rows where 'runner_up' is 'tokai'.
title season winner score runner___up venue attendance

Step 3: Select rows where 'title' is '47th'.
title season winner score runner___up venue attendance

Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
title season winner score runner___up venue attendance

Final output table:
verification_result
FALSE

Prediction: FALSE

Ground-truth: FALSE