Step 1: Select rows where 'directed_by' is 'john moxey'.
episode |
prod |
title |
directed_by |
written_by |
originalairdate |
filmed |
1 |
104 |
diplomatic immunity |
leslie norman |
dennis spooner |
1966-09-28 |
1965-09-01 |
2 |
107 |
epitaph for a hero |
john moxey |
terry nation |
1966-10-05 |
1965-10-01 |
3 |
109 |
something for a rainy day |
cyril frankel |
terry nation |
1966-10-12 |
1965-11-01 |
4 |
102 |
red horse , red rider |
john moxey |
terry nation |
1966-10-19 |
1965-08-01 |
5 |
110 |
enemy of the state |
jeremy summers |
dennis spooner |
1966-10-26 |
1965-12-01 |
6 |
114 |
masquerade (part one) |
cyril frankel |
terry nation |
1966-11-02 |
1966-02-01 |
7 |
115 |
the killing (part two) |
cyril frankel |
terry nation |
1966-11-09 |
1966-02-01 |
8 |
108 |
the persuaders |
leslie norman |
dennis spooner |
1966-11-16 |
1965-10-01 |
9 |
112 |
and suddenly you 're dead |
cyril frankel |
terry nation and dennis spooner |
1966-11-23 |
1966-01-01 |
10 |
103 |
the legions of ammak |
john moxey |
michael cramoy |
1966-11-30 |
1965-08-01 |
11 |
101 |
samurai west |
john moxey |
brian degas |
1966-12-07 |
1965-07-01 |
12 |
123 |
the maze |
jeremy summers |
tony o'grady (pseudonym of brian clemens) |
1966-12-14 |
1966-06-01 |
13 |
105 |
portrait of louisa |
john moxey |
terry nation |
1966-12-21 |
1965-09-01 |
14 |
111 |
there 's somebody close behind you |
roy baker |
terry nation and dennis spooner |
1966-12-28 |
1965-12-01 |
15 |
125 |
storm warning (part one) |
gordon flemyng |
terry nation |
1967-01-04 |
1966-07-01 |
16 |
126 |
the island (part two) |
gordon flemyng |
terry nation |
1967-01-11 |
1966-07-01 |
17 |
121 |
time to kill |
jeremy summers |
dennis spooner |
1967-01-18 |
1966-05-01 |
18 |
113 |
a memory of evil |
don chaffey |
terry nation and dennis spooner |
1967-01-25 |
1966-01-01 |
19 |
117 |
you can't win them all |
don chaffey |
dennis spooner |
1967-02-01 |
1966-04-01 |
20 |
128 |
the high terrace |
robert asher |
dennis spooner |
1967-02-08 |
1966-09-01 |
21 |
118 |
the seven eyes of night |
robert asher |
terry nation |
1967-02-15 |
1966-04-01 |
22 |
124 |
night of the hunter |
roy baker |
terry nation |
1967-02-22 |
1966-07-01 |
23 |
120 |
the edge of fear |
quentin lawrence |
dennis spooner |
1967-03-01 |
1966-05-01 |
24 |
116 |
long ago and far away |
robert asher |
dennis spooner |
1967-03-08 |
1966-04-01 |
25 |
122 |
so dark the night |
robert tronson |
terry nation and dennis spooner |
1967-03-15 |
1966-06-01 |
26 |
119 |
the long , long day |
roy baker |
tony o'grady |
1967-03-22 |
1966-04-01 |
27 |
127 |
roundabout |
robert tronson |
terry nation |
1967-03-29 |
1966-08-01 |
28 |
129 |
the man outside |
roy baker |
terry nation |
1967-04-05 |
1966-09-01 |
29 |
130 |
countdown |
robert asher |
terry nation |
1967-04-12 |
1966-10-01 |
Step 2: Select rows where 'written_by' is 'tony o'grady (pseudonym of brian clemens)'.
episode |
prod |
title |
directed_by |
written_by |
originalairdate |
filmed |
2 |
107 |
epitaph for a hero |
john moxey |
terry nation |
1966-10-05 |
1965-10-01 |
4 |
102 |
red horse , red rider |
john moxey |
terry nation |
1966-10-19 |
1965-08-01 |
10 |
103 |
the legions of ammak |
john moxey |
michael cramoy |
1966-11-30 |
1965-08-01 |
11 |
101 |
samurai west |
john moxey |
brian degas |
1966-12-07 |
1965-07-01 |
13 |
105 |
portrait of louisa |
john moxey |
terry nation |
1966-12-21 |
1965-09-01 |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
episode |
prod |
title |
directed_by |
written_by |
originalairdate |
filmed |
verification_result |
FALSE |