Plan-of-SQLs Interface TN

Sample: 1787/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: in 2009 , the mixed double consists of didit juang indrianto and yayu rahayu and hermansyah is the boys singles

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 'mixed_doubles' is 'didit juang indrianto yayu rahayu'.

Step 3: Select rows where 'boys_singles' is 'hermansyah'.

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 'mixed_doubles' is 'didit juang indrianto yayu rahayu'.

SQL command for the step:

SELECT * FROM table_sql WHERE mixed_doubles = 'didit juang indrianto yayu rahayu';
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 'boys_singles' is 'hermansyah'.

SQL command for the step:

SELECT * FROM table_sql WHERE boys_singles = 'hermansyah';
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 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