Step 1: Select rows where 'production_code' is '2arg24'.
no_in_series |
no_in_season |
title |
directed_by |
written_by |
original_air_date |
production_code |
us_viewers__millions |
25 |
1 |
the old wagon |
michael spiller |
bill wrubel |
2010-09-22 |
2arg05 |
12.67 |
26 |
2 |
the kiss |
scott ellis |
abraham higginbotham |
2010-09-29 |
2arg04 |
11.92 |
27 |
3 |
earthquake |
michael spiller |
paul corrigan & brad walsh |
2010-10-06 |
2arg01 |
11.44 |
28 |
4 |
strangers on a treadmill |
scott ellis |
danny zuker |
2010-10-13 |
2arg02 |
11.45 |
29 |
5 |
unplugged |
michael spiller |
steven levitan |
2010-10-20 |
2arg06 |
11.97 |
30 |
6 |
halloween |
michael spiller |
jeffrey richman |
2010-10-27 |
2arg09 |
13.14 |
31 |
7 |
chirp |
michael spiller |
dan o 'shannon |
2010-11-03 |
2arg03 |
12.24 |
32 |
8 |
manny get your gun |
michael spiller |
teleplay : danny zuker story : christopher lloyd |
2010-11-17 |
2arg11 |
12.09 |
33 |
9 |
mother tucker |
michael spiller |
paul corrigan & brad walsh |
2010-11-24 |
2arg07 |
10.57 |
34 |
10 |
dance dance revelation |
gail mancuso |
ilana wernick |
2010-12-08 |
2arg08 |
11.07 |
35 |
11 |
slow down your neighbors |
gail mancuso |
ilana wernick |
2011-01-05 |
2arg12 |
11.83 |
36 |
12 |
our children , ourselves |
adam shankman |
dan o 'shannon & bill wrubel |
2011-01-12 |
2arg10 |
11.12 |
37 |
13 |
caught in the act |
michael spiller |
steven levitan & jeffrey richman |
2011-01-19 |
2arg13 |
10.94 |
38 |
14 |
bixby 's back |
chris koch |
danny zuker |
2011-02-09 |
2arg16 |
13.16 |
39 |
15 |
princess party |
michael spiller |
elaine ko |
2011-02-16 |
2arg17 |
10.57 |
40 |
16 |
regrets only |
dean parisot |
abraham higginbotham |
2011-02-23 |
2arg14 |
10.17 |
41 |
17 |
two monkeys and a panda |
beth mccarthy - miller |
carol leifer |
2011-03-02 |
2arg15 |
10.11 |
42 |
18 |
boys' night |
chris koch |
steven levitan & jeffrey richman |
2011-03-23 |
2arg20 |
10.9 |
43 |
19 |
the musical man |
michael spiller |
paul corrigan & brad walsh |
2011-04-13 |
2arg19 |
9.61 |
44 |
20 |
someone to watch over lily |
michael spiller |
bill wrubel |
2011-04-20 |
2arg18 |
9.95 |
45 |
21 |
mother 's day |
michael spiller |
dan o 'shannon & ilana wernick |
2011-05-04 |
2arg21 |
9.9 |
47 |
23 |
see you next fall |
steven levitan |
danny zuker |
2011-05-18 |
2arg24 |
10.3 |
Step 2: Select rows where 'original_air_date' is '2011-05-18'.
no_in_series |
no_in_season |
title |
directed_by |
written_by |
original_air_date |
production_code |
us_viewers__millions |
47 |
23 |
see you next fall |
steven levitan |
danny zuker |
2011-05-18 |
2arg24 |
10.3 |
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 |
original_air_date |
production_code |
us_viewers__millions |
47 |
23 |
see you next fall |
steven levitan |
danny zuker |
2011-05-18 |
2arg24 |
10.3 |
Prediction: TRUE
Ground-truth: TRUE