Interactive POS Demo

Task: Verify the Statement against the Table

Statement: nadia al - moutawaa was the first person to win the gold medal in equestrian at the asian games and win silver another year

Table: equestrian at the asian games

year	location	gold	silver	bronze
1982	new delhi	nadia al - moutawaa	jamila al - moutawaa	bariaa salem al - sabbah
1986	seoul	takashi tomura	shuichi toki	ryuzo okuno
1994	hiroshima	konoshin kuwahara	ryuzo okuno	natya chantrasmi
1998	bangkok	jin kanno	sohn bong - gak	quzier ambak fathil
2002	busan	mikaela marãa jaworski	lee jin - kyung	tadayoshi hayashi
2006	doha	ali yousuf al - rumaihi	jasmine chen - shao man	joo jung - hyun
2010	guangzhou	ramzy al duhami	latifa al maktom	khaled al - eid

Generating plan to answer the query...

Generated steps

Step 1: Order the table by 'year' in ascending order.

Step 2: Select rows where 'gold' is 'nadia al - moutawaa'.

Step 3: Select rows where 'silver' is not 'nadia al - moutawaa'.

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

Step 1: Order the table by 'year' in ascending order.

SQL command for the step:

SELECT * FROM table_sql ORDER BY year ASC;

year	location	gold	silver	bronze
1982	new delhi	nadia al - moutawaa	jamila al - moutawaa	bariaa salem al - sabbah
1986	seoul	takashi tomura	shuichi toki	ryuzo okuno
1994	hiroshima	konoshin kuwahara	ryuzo okuno	natya chantrasmi
1998	bangkok	jin kanno	sohn bong - gak	quzier ambak fathil
2002	busan	mikaela marãa jaworski	lee jin - kyung	tadayoshi hayashi
2006	doha	ali yousuf al - rumaihi	jasmine chen - shao man	joo jung - hyun
2010	guangzhou	ramzy al duhami	latifa al maktom	khaled al - eid

Step 2: Select rows where 'gold' is 'nadia al - moutawaa'.

SQL command for the step:

SELECT * FROM table_sql WHERE gold = 'nadia al - moutawaa';

year	location	gold	silver	bronze
1982	new delhi	nadia al - moutawaa	jamila al - moutawaa	bariaa salem al - sabbah
1986	seoul	takashi tomura	shuichi toki	ryuzo okuno
1994	hiroshima	konoshin kuwahara	ryuzo okuno	natya chantrasmi
1998	bangkok	jin kanno	sohn bong - gak	quzier ambak fathil
2002	busan	mikaela marãa jaworski	lee jin - kyung	tadayoshi hayashi
2006	doha	ali yousuf al - rumaihi	jasmine chen - shao man	joo jung - hyun
2010	guangzhou	ramzy al duhami	latifa al maktom	khaled al - eid

Step 3: Select rows where 'silver' is not 'nadia al - moutawaa'.

SQL command for the step:

SELECT * FROM table_sql WHERE silver <> 'nadia al - moutawaa';

year	location	gold	silver	bronze
1982	new delhi	nadia al - moutawaa	jamila al - moutawaa	bariaa salem al - sabbah

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	location	gold	silver	bronze
1982	new delhi	nadia al - moutawaa	jamila al - moutawaa	bariaa salem al - sabbah

Verification:

The statement is TRUE