Step 1: Select rows where 'series' is 50.
series |
season |
title |
directed_by |
written_by |
original_air_date |
us_viewers__in_millions |
45 |
1 |
the long way down job |
dean devlin |
joe hortua & john rogers |
2011-06-26 |
3.42 |
46 |
2 |
the 10 li'l grifters job |
arvin brown |
geoffrey thorne |
2011-07-03 |
2.46 |
47 |
3 |
the 15 minutes job |
marc roskin |
josh schaer |
2011-07-10 |
3.24 |
48 |
4 |
the van gogh job |
john rogers |
chris downey |
2011-07-17 |
4.06 |
49 |
5 |
the hot potato job |
john harrison |
jenn kao |
2011-07-24 |
3.25 |
50 |
6 |
the carnival job |
frank oz |
m scott veach & paul guyot |
2011-07-31 |
3.38 |
51 |
7 |
the grave danger job |
john harrison |
rebecca kirsch |
2011-08-14 |
3.36 |
52 |
8 |
the boiler room job |
arvin brown |
paul guyot |
2011-08-14 |
3.29 |
54 |
10 |
the queen 's gambit job |
jonathan frakes |
m scott veach & rebecca kirsch |
2011-08-28 |
3.22 |
55 |
11 |
the experimental job |
marc roskin |
m scott veach |
2011-11-27 |
2.1 |
56 |
12 |
the office job |
jonathan frakes |
jeremy bernstein & josh schaer |
2011-12-04 |
1.83 |
57 |
13 |
the girls' night out job |
marc roskin |
chris downey & jenn kao |
2011-12-11 |
1.83 |
58 |
14 |
the boys' night out job |
john rogers |
john rogers |
2011-12-18 |
2.11 |
59 |
15 |
the lonely hearts job |
jonathan frakes |
kerry glover |
2011-12-25 |
1.99 |
60 |
16 |
the gold job |
marc roskin |
joe hortua |
2012-01-01 |
2.26 |
61 |
17 |
the radio job |
dean devlin |
chris downey & paul guyot |
2012-01-08 |
2.32 |
Step 2: Select rows where 'us_viewers__in_millions' is 3.38.
series |
season |
title |
directed_by |
written_by |
original_air_date |
us_viewers__in_millions |
50 |
6 |
the carnival job |
frank oz |
m scott veach & paul guyot |
2011-07-31 |
3.38 |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
series |
season |
title |
directed_by |
written_by |
original_air_date |
us_viewers__in_millions |
50 |
6 |
the carnival job |
frank oz |
m scott veach & paul guyot |
2011-07-31 |
3.38 |
Prediction: TRUE
Ground-truth: TRUE