Step 1: Select rows where 'episode_title' is 'the expulsion'.
episode |
series |
episode_title |
original_air_date |
production_code |
27 |
1 |
return to genesis |
2008-04-05 |
201 |
28 |
2 |
the suspension |
2008-04-06 |
202 |
29 |
3 |
a team reinvented |
2008-04-12 |
203 |
30 |
4 |
the new captain |
2008-04-13 |
204 |
31 |
5 |
the homecoming |
2008-04-19 |
205 |
32 |
6 |
netherball rules! |
2008-04-20 |
206 |
33 |
7 |
doubts within |
2008-04-26 |
207 |
34 |
8 |
rocket 's decent |
2008-04-27 |
208 |
35 |
9 |
the all - stars |
2008-05-03 |
209 |
36 |
10 |
rocket vs sinedd |
2008-05-04 |
210 |
37 |
11 |
the champions stumble |
2008-05-10 |
211 |
38 |
12 |
last stand |
2008-05-11 |
212 |
39 |
13 |
fluxless |
2008-05-17 |
213 |
40 |
14 |
new order |
2008-07-26 |
214 |
41 |
15 |
revelations |
2008-07-27 |
215 |
42 |
16 |
new rules |
2008-08-02 |
216 |
43 |
17 |
open doors |
2008-08-03 |
217 |
44 |
18 |
warren steps in |
2008-08-09 |
218 |
45 |
19 |
the technodroid v3s |
2008-08-10 |
219 |
46 |
20 |
the fallen star |
2008-08-16 |
220 |
47 |
21 |
coach artegor |
2008-08-17 |
221 |
48 |
22 |
rocket , the midfielder |
2008-08-23 |
222 |
49 |
23 |
destiny |
2008-08-24 |
223 |
50 |
24 |
final preparations |
2008-08-31 |
224 |
51 |
25 |
a team unravels |
2008-08-31 |
225 |
Step 2: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
episode |
series |
episode_title |
original_air_date |
production_code |
Final output table:
verification_result |
FALSE |
Prediction: FALSE