Step 1: Select rows where 'title' is 'sweet dreams'.
| no_overall |
no_for_series |
title |
directed_by |
written_by |
original_air_date |
uk_viewers__million |
| 14 |
1 |
the curse of cornelius sigan |
david moore |
julian jones |
2009-09-19 |
5.77 |
| 15 |
2 |
the once and future queen |
jeremy webb |
howard overman |
2009-09-26 |
5.94 |
| 16 |
3 |
the nightmare begins |
jeremy webb |
ben vanstone |
2009-10-03 |
6.09 |
| 17 |
4 |
lancelot and guinevere |
david moore |
howard overman |
2009-10-10 |
5.69 |
| 18 |
5 |
beauty and the beast (part 1) |
david moore |
jake michie |
2009-10-24 |
5.53 |
| 19 |
6 |
beauty and the beast (part 2) |
metin huseyin |
ben vanstone |
2009-10-31 |
6.14 |
| 20 |
7 |
the witchfinder |
jeremy webb |
jake michie |
2009-11-07 |
5.62 |
| 21 |
8 |
the sins of the father |
metin huseyin |
howard overman |
2009-11-14 |
6.16 |
| 22 |
9 |
the lady of the lake |
metin huseyin |
julian jones |
2009-11-21 |
6.3 |
| 23 |
10 |
sweet dreams |
alice troughton |
lucy watkins |
2009-11-28 |
6.02 |
| 24 |
11 |
the witch 's quickening |
alice troughton |
jake michie |
2009-12-05 |
6.01 |
| 25 |
12 |
the fires of idirsholas |
jeremy webb |
julian jones |
2009-12-12 |
6.01 |
Step 2: Select rows where 'title' is 'the witchfinder'.
| no_overall |
no_for_series |
title |
directed_by |
written_by |
original_air_date |
uk_viewers__million |
| 23 |
10 |
sweet dreams |
alice troughton |
lucy watkins |
2009-11-28 |
6.02 |
Step 3: Use a `CASE` statement to return TRUE if the number of rows for 'sweet dreams' is greater than the number of rows for 'the witchfinder', otherwise return FALSE.
| no_overall |
no_for_series |
title |
directed_by |
written_by |
original_air_date |
uk_viewers__million |
Final output table:
| verification_result |
| FALSE |
Prediction: FALSE
Ground-truth: TRUE