Plan-of-SQLs Interface TP

Sample: 1742/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: the gold medalist for equestrian at the asian games has been different in every year they have occurred

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 not equal to the previous row's 'gold'.

Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to the number of rows in the table, 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 not equal to the previous row's 'gold'.

SQL command for the step:

SELECT *, LAG(gold) OVER (ORDER BY id) AS previous_gold FROM table_sql WHERE gold <> LAG(gold) OVER (ORDER BY id);
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: Use a `CASE` statement to return TRUE if the number of rows is equal to the number of rows in the table, otherwise return FALSE.

SQL command for the step:

SELECT CASE WHEN (SELECT COUNT(*) FROM table_sql) = (SELECT COUNT(*) FROM table_sql) THEN TRUE ELSE FALSE END AS verification;
year location gold silver bronze prev_gold
1986 seoul takashi tomura shuichi toki ryuzo okuno nadia al - moutawaa
1994 hiroshima konoshin kuwahara ryuzo okuno natya chantrasmi takashi tomura
1998 bangkok jin kanno sohn bong - gak quzier ambak fathil konoshin kuwahara
2002 busan mikaela marã­a jaworski lee jin - kyung tadayoshi hayashi jin kanno
2006 doha ali yousuf al - rumaihi jasmine chen - shao man joo jung - hyun mikaela marã­a jaworski
2010 guangzhou ramzy al duhami latifa al maktom khaled al - eid ali yousuf al - rumaihi

Verification:

The statement is TRUE