Statement: the episode that aired on december 17th had a higher production number than than the ray j episode and the episode titled '702'
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 nick_prod FROM table_sql WHERE original_air_date = '1996-12-17') >
(SELECT nick_prod FROM table_sql WHERE episode_title = 'ray j') AND
(SELECT nick_prod FROM table_sql WHERE episode_title = '702')
THEN 'TRUE'
ELSE 'FALSE'
END;