Plan-of-SQLs (Ours)

Statement: the episode called aaliyah was shown later than the episode that has nick production number one higher

Ground-truth: TRUE

Input Table: list of all that episodes

Step 1: Select rows where 'episode_title' is 'aaliyah'.
season series episode_title original_air_date nick_prod
1 38 tia & tamera mowry / ll cool j 1996-11-16 338
2 39 montell jordan 1996-11-23 339
4 41 dru hill 1996-12-07 341
5 42 tyra banks / blackstreet 1996-12-14 342
6 43 music special 1996-12-17 343
7 44 a tribe called quest 1996-12-21 344
8 45 702 1996-12-28 345
9 46 tony! toni! tone! 1997-01-04 346
10 47 chris farley / mint condition 1997-01-11 347
11 48 112 1997-01-18 348
12 49 sherman hemsley / nas 1997-01-25 349
13 50 john leguizamo / mona lisa 1997-02-01 350
14 51 ray j 1997-02-08 351
15 52 for real 1997-09-20 352
16 53 aaliyah 1997-10-04 353
17 54 az yet 1997-09-27 354
18 55 monica 1997-10-11 355
19 56 mc lyte 1997-10-18 356
Step 2: Extract the numerical value from the 'nick_prod' column to add column 'prod_num' to existing table.
season series episode_title original_air_date nick_prod
16 53 aaliyah 1997-10-04 353
Step 3: Select rows where 'prod_num' is greater than the prod_num of the episode with 'episode_title' one higher than 'aaliyah'.
season series episode_title original_air_date nick_prod prod_num
16 53 aaliyah 1997-10-04 353 353
Step 4: Use a `CASE` statement to return TRUE if the number of rows is greater than or equal to 1, otherwise return FALSE.
season series episode_title original_air_date nick_prod prod_num
Final output table:
verification_result
FALSE

Prediction: FALSE

Ground-truth: TRUE