Plan-of-SQLs Interface TN

Sample: 57/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: peter lowry 's pick number was 25

Table: 2008 mls superdraft

pick mls_team player position affiliation
15 san jose earthquakes shea salinas m furman carolina dynamo
16 new york red bulls eric brunner d ohio state michigan bucks
17 real salt lake alex nimo f generation adidas
18 new england revolution michael videira m duke cary railhawks u23 's
19 fc dallas eric avila m uc santa barbara ventura county fusion
20 columbus crew george josten m / f gonzaga michigan bucks
21 los angeles galaxy ely allen f / m washington
22 columbus crew ricardo pierre - louis f lee university cape cod crusaders
23 kansas city wizards yomby william d old dominion hampton roads piranhas
24 dc united andrew jacobson m california
25 kansas city wizards jonathan leathers d furman atlanta silverbacks u23 's
26 chicago fire peter lowry m / f santa clara san jose frogs
27 new england revolution joe germanese m duke cary railhawks u23 's
28 toronto fc brian edwards gk wake forest
Generating plan to answer the query...

Generated steps

Step 1: Select rows where 'player' is 'peter lowry'.

Step 2: Select rows where 'pick' is 25.

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

Step 1: Select rows where 'player' is 'peter lowry'.

SQL command for the step:

SELECT * FROM table_sql WHERE player = 'peter lowry';
pick mls_team player position affiliation
15 san jose earthquakes shea salinas m furman carolina dynamo
16 new york red bulls eric brunner d ohio state michigan bucks
17 real salt lake alex nimo f generation adidas
18 new england revolution michael videira m duke cary railhawks u23 's
19 fc dallas eric avila m uc santa barbara ventura county fusion
20 columbus crew george josten m / f gonzaga michigan bucks
21 los angeles galaxy ely allen f / m washington
22 columbus crew ricardo pierre - louis f lee university cape cod crusaders
23 kansas city wizards yomby william d old dominion hampton roads piranhas
24 dc united andrew jacobson m california
25 kansas city wizards jonathan leathers d furman atlanta silverbacks u23 's
26 chicago fire peter lowry m / f santa clara san jose frogs
27 new england revolution joe germanese m duke cary railhawks u23 's
28 toronto fc brian edwards gk wake forest

Step 2: Select rows where 'pick' is 25.

SQL command for the step:

SELECT * FROM table_sql WHERE pick = 25;
pick mls_team player position affiliation
26 chicago fire peter lowry m / f santa clara san jose frogs

Step 3: 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;
pick mls_team player position affiliation

Verification:

The statement is FALSE