Plan-of-SQLs Interface TN

Sample: 1706/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: only one person has been a member of the socialist party of albania

Table: list of prime ministers of albania

name born___died term_start term_end political_party
prime ministers 1991 onwards 1991-01-01 1991-01-01 1991-01-01 prime ministers 1991 onwards
fatos nano (1st time) 9999-01-01 1991-02-22 1991-06-05 party of labour of albania
ylli bufi 9999-01-01 1991-06-05 1991-12-10 socialist party of albania
vilson ahmeti 9999-01-01 1991-12-10 1992-04-13 non - party
aleksandër meksi 9999-01-01 1992-04-13 1997-03-11 democratic party of albania
bashkim fino 9999-01-01 1997-03-11 1997-07-24 socialist party of albania
fatos nano (2nd time) 9999-01-01 1997-07-24 1998-10-02 socialist party of albania
pandeli majko (1st time) 9999-01-01 1998-10-02 1999-10-29 socialist party of albania
ilir meta 9999-01-01 1999-10-29 2002-02-22 socialist party of albania
pandeli majko (2nd time) 9999-01-01 2002-02-22 2002-07-31 socialist party of albania
fatos nano (3rd time) 9999-01-01 2002-07-31 2005-09-11 socialist party of albania
sali berisha 1944-01-01 2005-09-11 2013-09-15 democratic party of albania
edi rama 9999-01-01 2013-09-15 9999-01-01 socialist party of albania
Generating plan to answer the query...

Generated steps

Step 1: Select rows where 'political_party' is 'socialist party of albania'.

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

Step 1: Select rows where 'political_party' is 'socialist party of albania'.

SQL command for the step:

SELECT * FROM table_sql WHERE political_party = 'socialist party of albania';
name born___died term_start term_end political_party
prime ministers 1991 onwards 1991-01-01 1991-01-01 1991-01-01 prime ministers 1991 onwards
fatos nano (1st time) 9999-01-01 1991-02-22 1991-06-05 party of labour of albania
ylli bufi 9999-01-01 1991-06-05 1991-12-10 socialist party of albania
vilson ahmeti 9999-01-01 1991-12-10 1992-04-13 non - party
aleksandër meksi 9999-01-01 1992-04-13 1997-03-11 democratic party of albania
bashkim fino 9999-01-01 1997-03-11 1997-07-24 socialist party of albania
fatos nano (2nd time) 9999-01-01 1997-07-24 1998-10-02 socialist party of albania
pandeli majko (1st time) 9999-01-01 1998-10-02 1999-10-29 socialist party of albania
ilir meta 9999-01-01 1999-10-29 2002-02-22 socialist party of albania
pandeli majko (2nd time) 9999-01-01 2002-02-22 2002-07-31 socialist party of albania
fatos nano (3rd time) 9999-01-01 2002-07-31 2005-09-11 socialist party of albania
sali berisha 1944-01-01 2005-09-11 2013-09-15 democratic party of albania
edi rama 9999-01-01 2013-09-15 9999-01-01 socialist party of albania

Step 2: 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;
name born___died term_start term_end political_party
ylli bufi 9999-01-01 1991-06-05 1991-12-10 socialist party of albania
bashkim fino 9999-01-01 1997-03-11 1997-07-24 socialist party of albania
fatos nano (2nd time) 9999-01-01 1997-07-24 1998-10-02 socialist party of albania
pandeli majko (1st time) 9999-01-01 1998-10-02 1999-10-29 socialist party of albania
ilir meta 9999-01-01 1999-10-29 2002-02-22 socialist party of albania
pandeli majko (2nd time) 9999-01-01 2002-02-22 2002-07-31 socialist party of albania
fatos nano (3rd time) 9999-01-01 2002-07-31 2005-09-11 socialist party of albania
edi rama 9999-01-01 2013-09-15 9999-01-01 socialist party of albania

Verification:

The statement is FALSE