Plan-of-SQLs Interface TP

Sample: 103/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: the killing (part two) originally aired on 9 november 1966

Table: the baron

episode prod title directed_by written_by originalairdate filmed
1 104 diplomatic immunity leslie norman dennis spooner 1966-09-28 1965-09-01
2 107 epitaph for a hero john moxey terry nation 1966-10-05 1965-10-01
3 109 something for a rainy day cyril frankel terry nation 1966-10-12 1965-11-01
4 102 red horse , red rider john moxey terry nation 1966-10-19 1965-08-01
5 110 enemy of the state jeremy summers dennis spooner 1966-10-26 1965-12-01
6 114 masquerade (part one) cyril frankel terry nation 1966-11-02 1966-02-01
7 115 the killing (part two) cyril frankel terry nation 1966-11-09 1966-02-01
8 108 the persuaders leslie norman dennis spooner 1966-11-16 1965-10-01
9 112 and suddenly you 're dead cyril frankel terry nation and dennis spooner 1966-11-23 1966-01-01
10 103 the legions of ammak john moxey michael cramoy 1966-11-30 1965-08-01
11 101 samurai west john moxey brian degas 1966-12-07 1965-07-01
12 123 the maze jeremy summers tony o'grady (pseudonym of brian clemens) 1966-12-14 1966-06-01
13 105 portrait of louisa john moxey terry nation 1966-12-21 1965-09-01
14 111 there 's somebody close behind you roy baker terry nation and dennis spooner 1966-12-28 1965-12-01
15 125 storm warning (part one) gordon flemyng terry nation 1967-01-04 1966-07-01
16 126 the island (part two) gordon flemyng terry nation 1967-01-11 1966-07-01
17 121 time to kill jeremy summers dennis spooner 1967-01-18 1966-05-01
18 113 a memory of evil don chaffey terry nation and dennis spooner 1967-01-25 1966-01-01
19 117 you can't win them all don chaffey dennis spooner 1967-02-01 1966-04-01
20 128 the high terrace robert asher dennis spooner 1967-02-08 1966-09-01
21 118 the seven eyes of night robert asher terry nation 1967-02-15 1966-04-01
22 124 night of the hunter roy baker terry nation 1967-02-22 1966-07-01
23 120 the edge of fear quentin lawrence dennis spooner 1967-03-01 1966-05-01
24 116 long ago and far away robert asher dennis spooner 1967-03-08 1966-04-01
25 122 so dark the night robert tronson terry nation and dennis spooner 1967-03-15 1966-06-01
26 119 the long , long day roy baker tony o'grady 1967-03-22 1966-04-01
27 127 roundabout robert tronson terry nation 1967-03-29 1966-08-01
28 129 the man outside roy baker terry nation 1967-04-05 1966-09-01
29 130 countdown robert asher terry nation 1967-04-12 1966-10-01
Generating plan to answer the query...

Generated steps

Step 1: Select rows where 'title' is 'the killing (part two)'.

Step 2: Select rows where 'originalairdate' is '1966-11-09'.

Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.

Step 1: Select rows where 'title' is 'the killing (part two)'.

SQL command for the step:

SELECT * FROM table_sql WHERE title = 'the killing (part two)';
episode prod title directed_by written_by originalairdate filmed
1 104 diplomatic immunity leslie norman dennis spooner 1966-09-28 1965-09-01
2 107 epitaph for a hero john moxey terry nation 1966-10-05 1965-10-01
3 109 something for a rainy day cyril frankel terry nation 1966-10-12 1965-11-01
4 102 red horse , red rider john moxey terry nation 1966-10-19 1965-08-01
5 110 enemy of the state jeremy summers dennis spooner 1966-10-26 1965-12-01
6 114 masquerade (part one) cyril frankel terry nation 1966-11-02 1966-02-01
7 115 the killing (part two) cyril frankel terry nation 1966-11-09 1966-02-01
8 108 the persuaders leslie norman dennis spooner 1966-11-16 1965-10-01
9 112 and suddenly you 're dead cyril frankel terry nation and dennis spooner 1966-11-23 1966-01-01
10 103 the legions of ammak john moxey michael cramoy 1966-11-30 1965-08-01
11 101 samurai west john moxey brian degas 1966-12-07 1965-07-01
12 123 the maze jeremy summers tony o'grady (pseudonym of brian clemens) 1966-12-14 1966-06-01
13 105 portrait of louisa john moxey terry nation 1966-12-21 1965-09-01
14 111 there 's somebody close behind you roy baker terry nation and dennis spooner 1966-12-28 1965-12-01
15 125 storm warning (part one) gordon flemyng terry nation 1967-01-04 1966-07-01
16 126 the island (part two) gordon flemyng terry nation 1967-01-11 1966-07-01
17 121 time to kill jeremy summers dennis spooner 1967-01-18 1966-05-01
18 113 a memory of evil don chaffey terry nation and dennis spooner 1967-01-25 1966-01-01
19 117 you can't win them all don chaffey dennis spooner 1967-02-01 1966-04-01
20 128 the high terrace robert asher dennis spooner 1967-02-08 1966-09-01
21 118 the seven eyes of night robert asher terry nation 1967-02-15 1966-04-01
22 124 night of the hunter roy baker terry nation 1967-02-22 1966-07-01
23 120 the edge of fear quentin lawrence dennis spooner 1967-03-01 1966-05-01
24 116 long ago and far away robert asher dennis spooner 1967-03-08 1966-04-01
25 122 so dark the night robert tronson terry nation and dennis spooner 1967-03-15 1966-06-01
26 119 the long , long day roy baker tony o'grady 1967-03-22 1966-04-01
27 127 roundabout robert tronson terry nation 1967-03-29 1966-08-01
28 129 the man outside roy baker terry nation 1967-04-05 1966-09-01
29 130 countdown robert asher terry nation 1967-04-12 1966-10-01

Step 2: Select rows where 'originalairdate' is '1966-11-09'.

SQL command for the step:

SELECT * FROM table_sql WHERE originalairdate = '1966-11-09';
episode prod title directed_by written_by originalairdate filmed
7 115 the killing (part two) cyril frankel terry nation 1966-11-09 1966-02-01

Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.

SQL command for the step:

SELECT CASE WHEN COUNT(*) = 1 THEN TRUE ELSE FALSE END AS verification FROM table_sql;
episode prod title directed_by written_by originalairdate filmed
7 115 the killing (part two) cyril frankel terry nation 1966-11-09 1966-02-01

Verification:

The statement is TRUE