Plan-of-SQLs Interface TN

Sample: 1735/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: roberto gamarra is the outgoing manager of nejapa

Table: primera división de fútbol profesional apertura 2008

team outgoing_manager manner_of_departure date_of_vacancy replaced_by date_of_appointment position_in_table
nejapa mauricio cienfuegos mutual consent 2008-08-14 daniel uberti 2008-09-05 10th
firpo gerardo reinoso sacked 2008-08-25 oscar benitez 2008-09-02 7th
balboa gustavo de simone sacked 2008-08-30 roberto gamarra 2008-09-05 10th
alianza pablo centrone sacked 2008-09-14 carlos jurado 2008-09-16 5th
firpo oscar benítez sacked 2008-12-09 agustín castillo 2008-12-23 post - season (6th)
águila agustín castillo sacked 2008-12-15 pablo centrone 2008-12-24 post - season (semifinals)
fas nelson ancheta sacked 2008-12-27 roberto gamarra 2009-01-01 post - season (semifinals)
nejapa daniel uberti sacked 2008-12-29 nelson ancheta 2008-12-29 post - season (10th)
balboa roberto gamarra mutual consent 2009-01-01 carlos de toro 2009-01-16 post - season (7th)
Generating plan to answer the query...

Generated steps

Step 1: Select rows where 'outgoing_manager' is 'roberto gamarra'.

Step 2: Select rows where 'team' is 'nejapa'.

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 'outgoing_manager' is 'roberto gamarra'.

SQL command for the step:

SELECT * FROM table_sql WHERE outgoing_manager = 'roberto gamarra';
team outgoing_manager manner_of_departure date_of_vacancy replaced_by date_of_appointment position_in_table
nejapa mauricio cienfuegos mutual consent 2008-08-14 daniel uberti 2008-09-05 10th
firpo gerardo reinoso sacked 2008-08-25 oscar benitez 2008-09-02 7th
balboa gustavo de simone sacked 2008-08-30 roberto gamarra 2008-09-05 10th
alianza pablo centrone sacked 2008-09-14 carlos jurado 2008-09-16 5th
firpo oscar benítez sacked 2008-12-09 agustín castillo 2008-12-23 post - season (6th)
águila agustín castillo sacked 2008-12-15 pablo centrone 2008-12-24 post - season (semifinals)
fas nelson ancheta sacked 2008-12-27 roberto gamarra 2009-01-01 post - season (semifinals)
nejapa daniel uberti sacked 2008-12-29 nelson ancheta 2008-12-29 post - season (10th)
balboa roberto gamarra mutual consent 2009-01-01 carlos de toro 2009-01-16 post - season (7th)

Step 2: Select rows where 'team' is 'nejapa'.

SQL command for the step:

SELECT * FROM table_sql WHERE team = 'nejapa';
team outgoing_manager manner_of_departure date_of_vacancy replaced_by date_of_appointment position_in_table
balboa roberto gamarra mutual consent 2009-01-01 carlos de toro 2009-01-16 post - season (7th)

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;
team outgoing_manager manner_of_departure date_of_vacancy replaced_by date_of_appointment position_in_table

Verification:

The statement is FALSE