Plan-of-SQLs Interface TP

Sample: 60/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: fast friends originally aired on october 12 , 1993

Table: full house (season 7)

no_in_series no_in_season title directed_by written_by original_air_date
145 1 it was a dark and stormy night john tracy marc warren & dennis rinsler 1993-09-14
146 2 the apartment john tracy tom burkhard 1993-09-21
147 3 wrong - way tanner john tracy jamie tatham & chuck tatham 1993-09-28
148 4 tough love joel zwick ellen guylas 1993-10-05
149 5 fast friends john tracy bob sand 1993-10-12
150 6 smash club : the next generation john tracy carolyn omine 1993-10-19
151 7 high anxiety john tracy tom amundsen 1993-10-26
152 8 another opening , another no show joel zwick story by : elias davis teleplay by : tom burkhard 1993-11-02
153 9 the day of the rhino james o'keefe adam i lapidus 1993-11-09
154 10 the prying game john tracy ellen guylas 1993-11-16
155 11 the bicycle thief john tracy chuck tatham & jamie tatham 1993-11-23
156 12 support your local parents james o'keefe bob sand 1993-11-30
157 13 the perfect couple john tracy marc warren & dennis rinsler 1993-12-14
158 14 is it true about stephanie joel zwick carolyn omine 1994-01-04
159 15 the test john tracy dan chasin & linda lane 1994-01-11
160 16 joey 's funny valentine john tracy adam i lapidus 1994-01-25
161 17 the last dance john tracy tom amundsen 1994-02-08
162 18 kissing cousins john tracy tom burkhard 1994-02-15
163 19 love on the rocks tom rickard ellen guylas 1994-03-01
Generating plan to answer the query...

Generated steps

Step 1: Select rows where the 'original_air_date' is '1993-10-12'.

Step 2: Select rows where the 'title' is 'fast friends'.

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 the 'original_air_date' is '1993-10-12'.

SQL command for the step:

SELECT * FROM table_sql WHERE original_air_date = '1993-10-12';
no_in_series no_in_season title directed_by written_by original_air_date
145 1 it was a dark and stormy night john tracy marc warren & dennis rinsler 1993-09-14
146 2 the apartment john tracy tom burkhard 1993-09-21
147 3 wrong - way tanner john tracy jamie tatham & chuck tatham 1993-09-28
148 4 tough love joel zwick ellen guylas 1993-10-05
149 5 fast friends john tracy bob sand 1993-10-12
150 6 smash club : the next generation john tracy carolyn omine 1993-10-19
151 7 high anxiety john tracy tom amundsen 1993-10-26
152 8 another opening , another no show joel zwick story by : elias davis teleplay by : tom burkhard 1993-11-02
153 9 the day of the rhino james o'keefe adam i lapidus 1993-11-09
154 10 the prying game john tracy ellen guylas 1993-11-16
155 11 the bicycle thief john tracy chuck tatham & jamie tatham 1993-11-23
156 12 support your local parents james o'keefe bob sand 1993-11-30
157 13 the perfect couple john tracy marc warren & dennis rinsler 1993-12-14
158 14 is it true about stephanie joel zwick carolyn omine 1994-01-04
159 15 the test john tracy dan chasin & linda lane 1994-01-11
160 16 joey 's funny valentine john tracy adam i lapidus 1994-01-25
161 17 the last dance john tracy tom amundsen 1994-02-08
162 18 kissing cousins john tracy tom burkhard 1994-02-15
163 19 love on the rocks tom rickard ellen guylas 1994-03-01

Step 2: Select rows where the 'title' is 'fast friends'.

SQL command for the step:

SELECT * FROM table_sql WHERE title = 'fast friends';
no_in_series no_in_season title directed_by written_by original_air_date
149 5 fast friends john tracy bob sand 1993-10-12

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;
no_in_series no_in_season title directed_by written_by original_air_date
149 5 fast friends john tracy bob sand 1993-10-12

Verification:

The statement is TRUE