Statement: seasons 2 and 10 both aired in january , almost exactly one year apart
Input Table: list of all that episodes
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 |
SQL Command:
SELECT
CASE
WHEN (SELECT COUNT(*) FROM table_sql WHERE season = 2 AND strftime('%m', original_air_date) = '01') > 0
AND (SELECT COUNT(*) FROM table_sql WHERE season = 10 AND strftime('%m', original_air_date) = '01') > 0
AND (SELECT strftime('%Y', original_air_date) FROM table_sql WHERE season = 2) =
(SELECT strftime('%Y', original_air_date, '-1 year') FROM table_sql WHERE season = 10)
THEN 'TRUE'
ELSE 'FALSE'
END;