Plan-of-SQLs Interface FP

Sample: 37/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: steve stricker has the best score out of all of the players from the united states

Table: 2006 u.s. open (golf)

place player country score to_par
1 steve stricker united states 70 + 69 = 139 - 1
2 colin montgomerie scotland 69 + 71 = 140 e
t3 kenneth ferrie england 71 + 70 = 141 + 1
t3 geoff ogilvy australia 71 + 70 = 141 + 1
t5 jim furyk united states 70 + 72 = 142 + 2
t5 pádraig harrington ireland 70 + 72 = 142 + 2
t7 jason dufner united states 72 + 71 = 143 + 3
t7 graeme mcdowell northern ireland 71 + 72 = 143 + 3
t7 phil mickelson united states 70 + 73 = 143 + 3
t7 arron oberholser united states 75 + 68 = 143 + 3
Generating plan to answer the query...

Generated steps

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

Step 2: Select rows where 'country' is 'united states'.

Step 3: Select row number 1.

Step 4: Select rows where 'player' is 'steve stricker'.

Step 5: 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 'score' in ascending order.

SQL command for the step:

SELECT * FROM table_sql ORDER BY score ASC;
place player country score to_par
1 steve stricker united states 70 + 69 = 139 - 1
2 colin montgomerie scotland 69 + 71 = 140 e
t3 kenneth ferrie england 71 + 70 = 141 + 1
t3 geoff ogilvy australia 71 + 70 = 141 + 1
t5 jim furyk united states 70 + 72 = 142 + 2
t5 pádraig harrington ireland 70 + 72 = 142 + 2
t7 jason dufner united states 72 + 71 = 143 + 3
t7 graeme mcdowell northern ireland 71 + 72 = 143 + 3
t7 phil mickelson united states 70 + 73 = 143 + 3
t7 arron oberholser united states 75 + 68 = 143 + 3

Step 2: Select rows where 'country' is 'united states'.

SQL command for the step:

SELECT * FROM table_sql WHERE country = 'united states';
place player country score to_par
1 steve stricker united states 70 + 69 = 139 - 1
2 colin montgomerie scotland 69 + 71 = 140 e
t3 kenneth ferrie england 71 + 70 = 141 + 1
t3 geoff ogilvy australia 71 + 70 = 141 + 1
t5 jim furyk united states 70 + 72 = 142 + 2
t5 pádraig harrington ireland 70 + 72 = 142 + 2
t7 jason dufner united states 72 + 71 = 143 + 3
t7 graeme mcdowell northern ireland 71 + 72 = 143 + 3
t7 phil mickelson united states 70 + 73 = 143 + 3
t7 arron oberholser united states 75 + 68 = 143 + 3

Step 3: Select row number 1.

SQL command for the step:

SELECT * FROM table_sql LIMIT 1;
place player country score to_par
1 steve stricker united states 70 + 69 = 139 - 1
t5 jim furyk united states 70 + 72 = 142 + 2
t7 jason dufner united states 72 + 71 = 143 + 3
t7 phil mickelson united states 70 + 73 = 143 + 3
t7 arron oberholser united states 75 + 68 = 143 + 3

Step 4: Select rows where 'player' is 'steve stricker'.

SQL command for the step:

SELECT * FROM table_sql WHERE player = 'steve stricker';
place player country score to_par
1 steve stricker united states 70 + 69 = 139 - 1

Step 5: 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;
place player country score to_par
1 steve stricker united states 70 + 69 = 139 - 1

Verification:

The statement is TRUE