Step 1: Select the 'episode_title' column from the table.
season |
series |
episode_title |
original_air_date |
nick_prod |
1 |
38 |
tia & tamera mowry / ll cool j |
1996-11-16 |
338 |
2 |
39 |
montell jordan |
1996-11-23 |
339 |
4 |
41 |
dru hill |
1996-12-07 |
341 |
5 |
42 |
tyra banks / blackstreet |
1996-12-14 |
342 |
6 |
43 |
music special |
1996-12-17 |
343 |
7 |
44 |
a tribe called quest |
1996-12-21 |
344 |
8 |
45 |
702 |
1996-12-28 |
345 |
9 |
46 |
tony! toni! tone! |
1997-01-04 |
346 |
10 |
47 |
chris farley / mint condition |
1997-01-11 |
347 |
11 |
48 |
112 |
1997-01-18 |
348 |
12 |
49 |
sherman hemsley / nas |
1997-01-25 |
349 |
13 |
50 |
john leguizamo / mona lisa |
1997-02-01 |
350 |
14 |
51 |
ray j |
1997-02-08 |
351 |
15 |
52 |
for real |
1997-09-20 |
352 |
16 |
53 |
aaliyah |
1997-10-04 |
353 |
17 |
54 |
az yet |
1997-09-27 |
354 |
18 |
55 |
monica |
1997-10-11 |
355 |
19 |
56 |
mc lyte |
1997-10-18 |
356 |
Step 2: Use a regular expression or string matching function to check if each episode title contains at least one letter.
episode_title |
tia & tamera mowry / ll cool j |
montell jordan |
dru hill |
tyra banks / blackstreet |
music special |
a tribe called quest |
702 |
tony! toni! tone! |
chris farley / mint condition |
112 |
sherman hemsley / nas |
john leguizamo / mona lisa |
ray j |
for real |
aaliyah |
az yet |
monica |
mc lyte |
Step 3: Use a `CASE` statement to return TRUE if all episode titles satisfy the condition, otherwise return FALSE.
episode_title |
contains_letter |
tia & tamera mowry / ll cool j |
FALSE |
montell jordan |
FALSE |
dru hill |
FALSE |
tyra banks / blackstreet |
FALSE |
music special |
FALSE |
a tribe called quest |
FALSE |
702 |
FALSE |
tony! toni! tone! |
FALSE |
chris farley / mint condition |
FALSE |
112 |
FALSE |
sherman hemsley / nas |
FALSE |
john leguizamo / mona lisa |
FALSE |
ray j |
FALSE |
for real |
FALSE |
aaliyah |
FALSE |
az yet |
FALSE |
monica |
FALSE |
mc lyte |
FALSE |