Step 1: Select rows where the 'episode_title' starts with the letter 't'.
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 `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
season |
series |
episode_title |
original_air_date |
nick_prod |
1 |
38 |
tia & tamera mowry / ll cool j |
1996-11-16 |
338 |
5 |
42 |
tyra banks / blackstreet |
1996-12-14 |
342 |
9 |
46 |
tony! toni! tone! |
1997-01-04 |
346 |