Step 1: Select rows where 'title' is 'funhouse'.
series |
season |
title |
director__s_ |
writer__s_ |
original_airdate |
23 |
1 |
dream come true |
george kaczender |
thomas lazarus |
1989-10-02 |
24 |
2 |
heartbreak hotel |
william malone |
jonathan glassner |
1989-10-09 |
25 |
3 |
welcome to springwood |
ken wiederhorn |
a l katz and gilbert adler |
1989-10-16 |
26 |
4 |
photo finish |
tom desimone |
jonathan glassner |
1989-10-23 |
27 |
5 |
memory overload |
don weis |
michael kirschenbaum |
1989-10-30 |
28 |
6 |
lucky stiff |
william malone |
david braff |
1989-11-06 |
29 |
7 |
silence is golden |
chuck braverman |
jonathan glassner |
1989-11-13 |
30 |
8 |
bloodlines |
james quinn |
gilbert adler and a l katz |
1989-11-20 |
31 |
9 |
monkey dreams |
robert englund |
michael kirschenbaum |
1989-11-27 |
32 |
10 |
do you know where the kids are |
bill froelich |
wayne rice |
1989-12-04 |
33 |
11 |
dreams that kill |
tom de simone |
tom blumquist |
1989-12-11 |
34 |
12 |
what you don't know can kill you |
ken wiederhorn |
jonathan glassner |
1990-01-01 |
35 |
13 |
easy come , easy go |
william malone |
david braff |
1990-01-08 |
36 |
14 |
prime cut |
david calloway |
michael kirschenbaum |
1990-01-15 |
37 |
15 |
interior loft |
ken wiederhorn |
david braff |
1990-01-22 |
38 |
16 |
interior loft later |
ken wiederhorn |
jonathan glassner |
1990-01-29 |
39 |
17 |
funhouse |
gilbert adler |
al katz and gilbert adler |
1990-02-05 |
40 |
18 |
a family affair |
keith samples |
david braff |
1990-02-12 |
41 |
19 |
dust to dust |
jonathan glassner |
bill froehlich , david braff , and jonathan glassner |
1990-02-19 |
42 |
20 |
prisoner of love |
richard t schor |
richard beban |
1990-02-26 |
43 |
21 |
life sentence |
anita w addison |
david zuckerman |
1990-03-05 |
Step 2: Select rows where 'director__s_' is 'al katz'.
series |
season |
title |
director__s_ |
writer__s_ |
original_airdate |
39 |
17 |
funhouse |
gilbert adler |
al katz and gilbert adler |
1990-02-05 |
Step 3: Select rows where 'writer__s_' is 'gilbert adler'.
series |
season |
title |
director__s_ |
writer__s_ |
original_airdate |
Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
series |
season |
title |
director__s_ |
writer__s_ |
original_airdate |
verification_result |
FALSE |