Step 1: Select rows where 'original_air_date' is after October 2008.
no_in_series |
no_in_season |
title |
directed_by |
written_by |
original_air_date |
us_viewers__millions_ |
25 |
1 |
our father |
keith gordon |
clyde phillips |
2008-09-28 |
n / a |
26 |
2 |
finding freebo |
marcos siega |
melissa rosenberg |
2008-10-05 |
0.79 |
27 |
3 |
the lion sleeps tonight |
john dahl |
scott buck |
2008-10-12 |
n / a |
28 |
4 |
all in the family |
keith gordon |
adam e fierro |
2008-10-19 |
0.86 |
29 |
5 |
turning biminese |
marcos siega |
tim schlattmann |
2008-10-26 |
n / a |
30 |
6 |
sã se puede |
ernest dickerson |
charles h eglee |
2008-11-02 |
n / a |
31 |
7 |
easy as pie |
steve shill |
lauren gussis |
2008-11-09 |
n / a |
32 |
8 |
the damage a man can do |
marcos siega |
scott buck |
2008-11-16 |
n / a |
34 |
10 |
go your own way |
john dahl |
tim schlattmann |
2008-11-30 |
n / a |
35 |
11 |
i had a dream |
marcos siega |
charles h eglee and lauren gussis |
2008-12-07 |
n / a |
Step 2: Use a `CASE` statement to return TRUE if the number of rows is greater than or equal to 1, otherwise return FALSE.
no_in_series |
no_in_season |
title |
directed_by |
written_by |
original_air_date |
us_viewers__millions_ |
26 |
2 |
finding freebo |
marcos siega |
melissa rosenberg |
2008-10-05 |
0.79 |
27 |
3 |
the lion sleeps tonight |
john dahl |
scott buck |
2008-10-12 |
n / a |
28 |
4 |
all in the family |
keith gordon |
adam e fierro |
2008-10-19 |
0.86 |
29 |
5 |
turning biminese |
marcos siega |
tim schlattmann |
2008-10-26 |
n / a |
30 |
6 |
sã se puede |
ernest dickerson |
charles h eglee |
2008-11-02 |
n / a |
31 |
7 |
easy as pie |
steve shill |
lauren gussis |
2008-11-09 |
n / a |
32 |
8 |
the damage a man can do |
marcos siega |
scott buck |
2008-11-16 |
n / a |
34 |
10 |
go your own way |
john dahl |
tim schlattmann |
2008-11-30 |
n / a |
35 |
11 |
i had a dream |
marcos siega |
charles h eglee and lauren gussis |
2008-12-07 |
n / a |