Step 1: Select rows where 'no_in_series' is 11.
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 'us_viewers__million_' is 2.77.
no_in_series |
no_in_season |
title |
directed_by |
written_by |
us_viewers__million_ |
original_air_date |
production_code |
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 |
verification_result |
FALSE |