Plan-of-SQLs Interface TP

Sample: 1876/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: the one where everybody finds out is episode number 111.0

Table: friends (season 5)

no_in_series no_in_season title directed_by written_by original_air_date production_code us_viewers__millions_
98 1 the one after ross says rachel kevin s bright seth kurland 1998-09-24 467651 31.1
99 2 the one with all the kissing gary halvorson wil calhoun 1998-10-01 467652 25.4
100 3 the one hundredth the one with the triplets kevin s bright david crane & marta kauffman 1998-10-08 467653 26.8
101 4 the one where phoebe hates pbs shelley jensen michael curtis 1998-10-15 467654 24.1
102 5 the one with the kips dana devalley piazza scott silveri 1998-10-29 467655 25.9
103 6 the one with the yeti gary halvorson alexa junge 1998-11-05 467656 25.0
104 7 the one where ross moves in gary halvorson gigi mccreery & perry rein 1998-11-12 467657 24.4
105 8 the one with all the thanksgivings kevin s bright gregory s malins 1998-11-19 467659 23.9
106 9 the one with ross 's sandwich gary halvorson ted cohen & andrew reich 1998-12-10 467658 23.0
107 10 the one with the inappropriate sister dana devalley piazza shana goldberg - meehan 1998-12-17 467661 23.7
108 11 the one with all the resolutions joe regalbuto story : brian boyle teleplay : suzie villandry 1999-01-07 467660 27.0
109 12 the one with chandler 's work laugh kevin s bright alicia sky varinaitis 1999-01-21 467663 24.8
110 13 the one with joey 's bag gail mancuso story : michael curtis teleplay : seth kurland 1999-02-04 467662 24.9
111 14 the one where everybody finds out michael lembeck alexa junge 1999-02-11 467664 27.7
112 15 the one with the girl who hits joey kevin s bright adam chase 1999-02-18 467665 29.3
114 17 the one with rachel 's inadvertent kiss shelley jensen andrew reich & ted cohen 1999-03-18 467667 24.5
115 18 the one where rachel smokes todd holland michael curtis 1999-04-08 467668 21.9
116 19 the one where ross can't flirt gail mancuso doty abrams 1999-04-22 467669 20.9
117 20 the one with the ride - along gary halvorson shana goldberg - meehan & seth kurland 1999-04-29 467670 19.6
118 21 the one with the ball gary halvorson story : scott silveri teleplay : gregory s malins 1999-05-06 467671 20.9
Generating plan to answer the query...

Generated steps

Step 1: Select rows where the 'title' is 'the one where everybody finds out'.

Step 2: Select the 'no_in_series' column from the resulting table.

Step 3: Use a `CASE` statement to return TRUE if the value in the 'no_in_series' column is equal to 111.0, otherwise return FALSE.

Step 1: Select rows where the 'title' is 'the one where everybody finds out'.

SQL command for the step:

SELECT * FROM table_sql WHERE title = 'the one where everybody finds out';
no_in_series no_in_season title directed_by written_by original_air_date production_code us_viewers__millions_
98 1 the one after ross says rachel kevin s bright seth kurland 1998-09-24 467651 31.1
99 2 the one with all the kissing gary halvorson wil calhoun 1998-10-01 467652 25.4
100 3 the one hundredth the one with the triplets kevin s bright david crane & marta kauffman 1998-10-08 467653 26.8
101 4 the one where phoebe hates pbs shelley jensen michael curtis 1998-10-15 467654 24.1
102 5 the one with the kips dana devalley piazza scott silveri 1998-10-29 467655 25.9
103 6 the one with the yeti gary halvorson alexa junge 1998-11-05 467656 25.0
104 7 the one where ross moves in gary halvorson gigi mccreery & perry rein 1998-11-12 467657 24.4
105 8 the one with all the thanksgivings kevin s bright gregory s malins 1998-11-19 467659 23.9
106 9 the one with ross 's sandwich gary halvorson ted cohen & andrew reich 1998-12-10 467658 23.0
107 10 the one with the inappropriate sister dana devalley piazza shana goldberg - meehan 1998-12-17 467661 23.7
108 11 the one with all the resolutions joe regalbuto story : brian boyle teleplay : suzie villandry 1999-01-07 467660 27.0
109 12 the one with chandler 's work laugh kevin s bright alicia sky varinaitis 1999-01-21 467663 24.8
110 13 the one with joey 's bag gail mancuso story : michael curtis teleplay : seth kurland 1999-02-04 467662 24.9
111 14 the one where everybody finds out michael lembeck alexa junge 1999-02-11 467664 27.7
112 15 the one with the girl who hits joey kevin s bright adam chase 1999-02-18 467665 29.3
114 17 the one with rachel 's inadvertent kiss shelley jensen andrew reich & ted cohen 1999-03-18 467667 24.5
115 18 the one where rachel smokes todd holland michael curtis 1999-04-08 467668 21.9
116 19 the one where ross can't flirt gail mancuso doty abrams 1999-04-22 467669 20.9
117 20 the one with the ride - along gary halvorson shana goldberg - meehan & seth kurland 1999-04-29 467670 19.6
118 21 the one with the ball gary halvorson story : scott silveri teleplay : gregory s malins 1999-05-06 467671 20.9

Step 2: Select the 'no_in_series' column from the resulting table.

SQL command for the step:

SELECT no_in_series FROM table_sql;
no_in_series no_in_season title directed_by written_by original_air_date production_code us_viewers__millions_
111 14 the one where everybody finds out michael lembeck alexa junge 1999-02-11 467664 27.7

Step 3: Use a `CASE` statement to return TRUE if the value in the 'no_in_series' column is equal to 111.0, otherwise return FALSE.

SQL command for the step:

SELECT CASE WHEN no_in_series = 111.0 THEN TRUE ELSE FALSE END AS verification FROM table_sql;
no_in_series
111

Verification:

The statement is TRUE