Step 1: Select rows where 'filmed' is between '1966-07-01' and '1966-08-31'.
| 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 'title' is 'storm warning (part one)'.
| episode |
prod |
title |
directed_by |
written_by |
originalairdate |
filmed |
| 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 |
| 22 |
124 |
night of the hunter |
roy baker |
terry nation |
1967-02-22 |
1966-07-01 |
| 27 |
127 |
roundabout |
robert tronson |
terry nation |
1967-03-29 |
1966-08-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 |
| 15 |
125 |
storm warning (part one) |
gordon flemyng |
terry nation |
1967-01-04 |
1966-07-01 |