Plan-of-SQLs Interface TN

Sample: 1738/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: daniel uberti was sacked on 29 december 2008 and replaced by carlos de toro on 29 december 2008

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 'daniel uberti'.

Step 2: Select rows where 'manner_of_departure' is 'sacked'.

Step 3: Select rows where 'date_of_vacancy' is '2008-12-29'.

Step 4: Select rows where 'replaced_by' is 'carlos de toro'.

Step 5: Select rows where 'date_of_appointment' is '2008-12-29'.

Step 6: 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 'daniel uberti'.

SQL command for the step:

SELECT * FROM table_sql WHERE outgoing_manager = 'daniel uberti';
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 'manner_of_departure' is 'sacked'.

SQL command for the step:

SELECT * FROM table_sql WHERE manner_of_departure = 'sacked';
team outgoing_manager manner_of_departure date_of_vacancy replaced_by date_of_appointment position_in_table
nejapa daniel uberti sacked 2008-12-29 nelson ancheta 2008-12-29 post - season (10th)

Step 3: Select rows where 'date_of_vacancy' is '2008-12-29'.

SQL command for the step:

SELECT * FROM table_sql WHERE date_of_vacancy = '2008-12-29';
team outgoing_manager manner_of_departure date_of_vacancy replaced_by date_of_appointment position_in_table
nejapa daniel uberti sacked 2008-12-29 nelson ancheta 2008-12-29 post - season (10th)

Step 4: Select rows where 'replaced_by' is 'carlos de toro'.

SQL command for the step:

SELECT * FROM table_sql WHERE replaced_by = 'carlos de toro';
team outgoing_manager manner_of_departure date_of_vacancy replaced_by date_of_appointment position_in_table
nejapa daniel uberti sacked 2008-12-29 nelson ancheta 2008-12-29 post - season (10th)

Step 5: Select rows where 'date_of_appointment' is '2008-12-29'.

SQL command for the step:

SELECT * FROM table_sql WHERE date_of_appointment = '2008-12-29';
team outgoing_manager manner_of_departure date_of_vacancy replaced_by date_of_appointment position_in_table

Step 6: 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