Plan-of-SQLs Interface FN

Sample: 54/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: joe germanese was the 27th pick

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: Order the table by 'pick' in ascending order.

Step 2: Select row number 27.

Step 3: Select rows where 'player' is 'joe germanese'.

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 'pick' in ascending order.

SQL command for the step:

SELECT * FROM table_sql ORDER BY pick ASC;
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 row number 27.

SQL command for the step:

SELECT * FROM table_sql LIMIT 1 OFFSET 26;
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 3: Select rows where 'player' is 'joe germanese'.

SQL command for the step:

SELECT * FROM table_sql WHERE player = 'joe germanese';
pick mls_team player position affiliation

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

Verification:

The statement is FALSE