Plan-of-SQLs (Ours)


Statement: the production code for the episode directed by robert duncan mcneill is bcw403

Ground-truth: FALSE

Input Table: list of white collar episodes

Step 1: Select rows where 'directed_by' is 'robert duncan mcneill'.
no_in_series no_in_season title directed_by written_by us_viewers__million original_air_date production_code
47 1 wanted paul holahan jeff eastin 3.21 2012-07-10 bcw401
48 2 most wanted paul holahan mark goffman 2.98 2012-07-17 bcw402
49 3 diminishing returns stefan schwartz jim campolongo 3.01 2012-07-24 bcw403
50 4 parting shots robert duncan mcneill alexandra mcnally 2.82 2012-07-31 bcw404
51 5 honor among thieves arlene sanford joe henderson 2.93 2012-08-14 bcw405
52 6 identity crisis david straiton channing powell 3.89 2012-08-21 bcw406
53 7 compromising positions paul holahan matthew negrete 3.36 2012-08-28 bcw407
54 8 ancient history russell lee fine daniel shattuck 3.38 2012-09-04 bcw408
55 9 gloves off renny harlin mark goffman 3.8 2012-09-11 bcw409
56 10 vested interest russell lee fine jeff eastin 3.41 2012-09-18 bcw410
57 11 family business paul holahan joe henderson 2.77 2013-01-22 bcw411
58 12 brass tacks anton cropper jim campolongo & alexandra mcnally 2.61 2013-01-29 bcw412
59 13 empire city tim dekay channing powell & daniel shattuck 2.28 2013-02-05 bcw413
60 14 shoot the moon russell lee fine matthew negrete & bob derosa 2.42 2013-02-19 bcw414
61 15 the original john kretchmer mark goffman 2.12 2013-02-26 bcw415

Step 2: Select rows where 'production_code' is 'bcw403'.
no_in_series no_in_season title directed_by written_by us_viewers__million original_air_date production_code
50 4 parting shots robert duncan mcneill alexandra mcnally 2.82 2012-07-31 bcw404

Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
no_in_series no_in_season title directed_by written_by us_viewers__million original_air_date production_code

Final output table:
verification_result
FALSE

Prediction: FALSE

Ground-truth: FALSE