Plan-of-SQLs Interface TP

Sample: 173/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: 7.2 is the rebound average when games is 125 and the rank is 7

Table: none

rank player years games reb_avg total_rebounds
1 jim nowers 1972-01-01 - 1976-01-01 112 9.4 1048
2 kenny sanders 1985-01-01 - 1989-01-01 107 9.6 1026
3 will thomas 2004-01-01 - 2008-01-01 131 7.6 993
4 george evans 1997-01-01 - 2001-01-01 116 8.2 953
5 robert dykes 1987-01-01 - 1991-01-01 122 7.5 925
6 andre gaddy 1977-01-01 - 1982-01-01 98 9.3 916
7 jai lewis 2002-01-01 - 2006-01-01 125 7.2 895
8 rob rose 1982-01-01 - 1986-01-01 113 7.1 805
9 herb estes 1973-01-01 - 1976-01-01 80 9.2 734
10 jesse young 1999-01-01 - 2003-01-01 115 6.2 708
Generating plan to answer the query...

Generated steps

Step 1: Select rows where 'games' is 125.

Step 2: Select rows where 'rank' is 7.

Step 3: Select rows where 'reb_avg' is 7.2.

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

Step 1: Select rows where 'games' is 125.

SQL command for the step:

SELECT * FROM table_sql WHERE games = 125;
rank player years games reb_avg total_rebounds
1 jim nowers 1972-01-01 - 1976-01-01 112 9.4 1048
2 kenny sanders 1985-01-01 - 1989-01-01 107 9.6 1026
3 will thomas 2004-01-01 - 2008-01-01 131 7.6 993
4 george evans 1997-01-01 - 2001-01-01 116 8.2 953
5 robert dykes 1987-01-01 - 1991-01-01 122 7.5 925
6 andre gaddy 1977-01-01 - 1982-01-01 98 9.3 916
7 jai lewis 2002-01-01 - 2006-01-01 125 7.2 895
8 rob rose 1982-01-01 - 1986-01-01 113 7.1 805
9 herb estes 1973-01-01 - 1976-01-01 80 9.2 734
10 jesse young 1999-01-01 - 2003-01-01 115 6.2 708

Step 2: Select rows where 'rank' is 7.

SQL command for the step:

SELECT * FROM table_sql WHERE rank = 7;
rank player years games reb_avg total_rebounds
7 jai lewis 2002-01-01 - 2006-01-01 125 7.2 895

Step 3: Select rows where 'reb_avg' is 7.2.

SQL command for the step:

SELECT * FROM table_sql WHERE reb_avg = 7.2;
rank player years games reb_avg total_rebounds
7 jai lewis 2002-01-01 - 2006-01-01 125 7.2 895

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;
rank player years games reb_avg total_rebounds
7 jai lewis 2002-01-01 - 2006-01-01 125 7.2 895

Verification:

The statement is TRUE