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 |