Plan-of-SQLs Interface TN

Sample: 1789/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: in 2009 , when the girls doubles is anneke feinya agustin and wenny setiawati , the mixed doubles is wifqi windarto and debby susanto

Table: indonesian national badminton championships

year boys_singles girls_singles boys_doubles girls_doubles mixed_doubles
2001 holvy de pauw maria kristin yulianti hendra setiawan joko riyadi lilyana natsir natalia poluakan hendra setiawan greysia polii
2002 andre kurniawan tedjono fransisca ratnasari ujang suherlan yoga ukikasah purwati meiliana jauhari muhammad rijal meiliana jauhari
2003 alamsyah yunus wiwis meilyanna fran kurniawan chandra kowi pia zebadiah nitya krishinda maheswari fran kurniawan yulianti
2004 andre kurniawan tedjono pia zebadiah aditya dwi putra i made agung pia zebadiah nitya krishinda maheswari lingga lie yulianti
2005 achmad rivai bellaetrix manuputty rio willianto davin prawidssa lily siswanti shendy puspa irawati abdul rahman richi puspita dili
2006 nugroho andi saputro sylvinna kurniawan danny bawa chrisnanta afiat yuris wirawan bellaetrix manuputty samantha lintang danny bawa chrisnanta debby susanto
2007 nandang arif lindaweni fanetri budi hartono yohanes rendy sugiarto anneke feinya agustin wenny setiawati wifqi windarto debby susanto
2008 hermansyah ana rovita didit juang indrianto seiko wahyu kusdianto suci rizki andini tiara rosalia nuraidah irfan fadhilah weni anggraeni
2009 riyanto subagja ana rovita jones ralfy jansen dandi prabudita ayu pratiwi anggi widia didit juang indrianto yayu rahayu
2010 shesar hiren rhustavito ganis nur rahmadani jones ralfy jansen dandi prabudita aris budiharti dian fitriani jones ralfy jansen nurbeta kwanrico
Generating plan to answer the query...

Generated steps

Step 1: Select rows where 'year' is 2009.

Step 2: Select rows where 'girls_doubles' is 'anneke feinya agustin and wenny setiawati'.

Step 3: Select rows where 'mixed_doubles' is 'wifqi windarto and debby susanto'.

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

Step 1: Select rows where 'year' is 2009.

SQL command for the step:

SELECT * FROM table_sql WHERE year = 2009;
year boys_singles girls_singles boys_doubles girls_doubles mixed_doubles
2001 holvy de pauw maria kristin yulianti hendra setiawan joko riyadi lilyana natsir natalia poluakan hendra setiawan greysia polii
2002 andre kurniawan tedjono fransisca ratnasari ujang suherlan yoga ukikasah purwati meiliana jauhari muhammad rijal meiliana jauhari
2003 alamsyah yunus wiwis meilyanna fran kurniawan chandra kowi pia zebadiah nitya krishinda maheswari fran kurniawan yulianti
2004 andre kurniawan tedjono pia zebadiah aditya dwi putra i made agung pia zebadiah nitya krishinda maheswari lingga lie yulianti
2005 achmad rivai bellaetrix manuputty rio willianto davin prawidssa lily siswanti shendy puspa irawati abdul rahman richi puspita dili
2006 nugroho andi saputro sylvinna kurniawan danny bawa chrisnanta afiat yuris wirawan bellaetrix manuputty samantha lintang danny bawa chrisnanta debby susanto
2007 nandang arif lindaweni fanetri budi hartono yohanes rendy sugiarto anneke feinya agustin wenny setiawati wifqi windarto debby susanto
2008 hermansyah ana rovita didit juang indrianto seiko wahyu kusdianto suci rizki andini tiara rosalia nuraidah irfan fadhilah weni anggraeni
2009 riyanto subagja ana rovita jones ralfy jansen dandi prabudita ayu pratiwi anggi widia didit juang indrianto yayu rahayu
2010 shesar hiren rhustavito ganis nur rahmadani jones ralfy jansen dandi prabudita aris budiharti dian fitriani jones ralfy jansen nurbeta kwanrico

Step 2: Select rows where 'girls_doubles' is 'anneke feinya agustin and wenny setiawati'.

SQL command for the step:

SELECT * FROM table_sql WHERE girls_doubles = 'anneke feinya agustin and wenny setiawati';
year boys_singles girls_singles boys_doubles girls_doubles mixed_doubles
2009 riyanto subagja ana rovita jones ralfy jansen dandi prabudita ayu pratiwi anggi widia didit juang indrianto yayu rahayu

Step 3: Select rows where 'mixed_doubles' is 'wifqi windarto and debby susanto'.

SQL command for the step:

SELECT * FROM table_sql WHERE mixed_doubles = 'wifqi windarto and debby susanto';
year boys_singles girls_singles boys_doubles girls_doubles mixed_doubles

Step 4: 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;
year boys_singles girls_singles boys_doubles girls_doubles mixed_doubles

Verification:

The statement is FALSE