Plan-of-SQLs Interface TP

Sample: 1812/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: when twickenham stoop was the venue on 28 march 2009 , the score was 22 - 12

Table: craig hall (rugby league born 1988)

date venue opponent result tournament scored
2007-04-06 twickenham stoop harlequins rl 30 - 28 super league 1
2007-05-26 jjb stadium wigan warriors 47 - 16 super league 1
2007-07-08 craven park hull kr 20 - 30 super league 1
2007-07-13 kc stadium harlequins rl 20 - 8 super league 1
2007-07-29 kc stadium salford city reds 48 - 26 super league 2
2007-08-17 belle vue wakefield trinity wildcats 24 - 42 super league 1
2008-02-08 halliwell jones stadium warrington wolves 38 - 20 super league 2
2008-03-02 galpharm stadium huddersfield giants 28 - 8 super league 1
2008-03-07 knowsley road st helens rlfc 30 - 29 super league 1
2008-04-11 the jungle castleford tigers 12 - 32 super league 2
2008-04-27 kc stadium huddersfield giants 28 - 20 super league 1
2008-06-15 kc stadium castleford tigers 40 - 14 super league 3
2008-07-12 belle vue wakefield trinity wildcats 18 - 26 super league 2
2008-07-20 kc stadium hull kr 44 - 18 super league 1
2009-02-27 kc stadium catalans dragons 28 - 12 super league 1
2009-03-15 odsal bradford bulls 24 - 36 super league 2
2009-03-28 twickenham stoop harlequins rl 22 - 12 super league 1
2009-07-17 kc stadium crusaders 22 - 6 super league 1
2009-07-25 craven park hull kr 24 - 18 super league 4
2009-08-21 kc stadium harlequins rl 26 - 6 super league 3
2009-09-04 jjb stadium wigan warriors 34 - 22 super league 1
2010-02-12 kc stadium huddersfield giants 14 - 6 super league 1
2010-02-26 kc stadium harlequins rl 28 - 4 super league 1
2010-03-05 kc stadium castleford tigers 42 - 22 super league 1
2010-03-12 jjb stadium wigan warriors 48 - 24 super league 1
2010-04-05 kc stadium warrington wolves 10 - 29 super league 1
2010-04-11 headingley carnegie leeds rhinos 46 - 30 super league 1
2010-06-11 kc stadium salford city reds 34 - 12 super league 2
2010-07-04 odsal bradford bulls 22 - 28 super league 1
2011-03-07 the jungle castleford tigers 27 - 14 super league 1
2011-03-18 the willows salford city reds 34 - 18 super league 2
2011-06-12 headingley carnegie leeds rhinos 44 - 14 super league 1
Generating plan to answer the query...

Generated steps

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

Step 2: Select rows where 'venue' is 'twickenham stoop'.

Step 3: Select rows where the 'date' is '2009-03-28'.

Step 4: Select rows where the 'result' is '22 - 12'.

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

SQL command for the step:

SELECT * FROM table_sql ORDER BY date ASC;
date venue opponent result tournament scored
2007-04-06 twickenham stoop harlequins rl 30 - 28 super league 1
2007-05-26 jjb stadium wigan warriors 47 - 16 super league 1
2007-07-08 craven park hull kr 20 - 30 super league 1
2007-07-13 kc stadium harlequins rl 20 - 8 super league 1
2007-07-29 kc stadium salford city reds 48 - 26 super league 2
2007-08-17 belle vue wakefield trinity wildcats 24 - 42 super league 1
2008-02-08 halliwell jones stadium warrington wolves 38 - 20 super league 2
2008-03-02 galpharm stadium huddersfield giants 28 - 8 super league 1
2008-03-07 knowsley road st helens rlfc 30 - 29 super league 1
2008-04-11 the jungle castleford tigers 12 - 32 super league 2
2008-04-27 kc stadium huddersfield giants 28 - 20 super league 1
2008-06-15 kc stadium castleford tigers 40 - 14 super league 3
2008-07-12 belle vue wakefield trinity wildcats 18 - 26 super league 2
2008-07-20 kc stadium hull kr 44 - 18 super league 1
2009-02-27 kc stadium catalans dragons 28 - 12 super league 1
2009-03-15 odsal bradford bulls 24 - 36 super league 2
2009-03-28 twickenham stoop harlequins rl 22 - 12 super league 1
2009-07-17 kc stadium crusaders 22 - 6 super league 1
2009-07-25 craven park hull kr 24 - 18 super league 4
2009-08-21 kc stadium harlequins rl 26 - 6 super league 3
2009-09-04 jjb stadium wigan warriors 34 - 22 super league 1
2010-02-12 kc stadium huddersfield giants 14 - 6 super league 1
2010-02-26 kc stadium harlequins rl 28 - 4 super league 1
2010-03-05 kc stadium castleford tigers 42 - 22 super league 1
2010-03-12 jjb stadium wigan warriors 48 - 24 super league 1
2010-04-05 kc stadium warrington wolves 10 - 29 super league 1
2010-04-11 headingley carnegie leeds rhinos 46 - 30 super league 1
2010-06-11 kc stadium salford city reds 34 - 12 super league 2
2010-07-04 odsal bradford bulls 22 - 28 super league 1
2011-03-07 the jungle castleford tigers 27 - 14 super league 1
2011-03-18 the willows salford city reds 34 - 18 super league 2
2011-06-12 headingley carnegie leeds rhinos 44 - 14 super league 1

Step 2: Select rows where 'venue' is 'twickenham stoop'.

SQL command for the step:

SELECT * FROM table_sql WHERE venue = 'twickenham stoop';
date venue opponent result tournament scored
2007-04-06 twickenham stoop harlequins rl 30 - 28 super league 1
2007-05-26 jjb stadium wigan warriors 47 - 16 super league 1
2007-07-08 craven park hull kr 20 - 30 super league 1
2007-07-13 kc stadium harlequins rl 20 - 8 super league 1
2007-07-29 kc stadium salford city reds 48 - 26 super league 2
2007-08-17 belle vue wakefield trinity wildcats 24 - 42 super league 1
2008-02-08 halliwell jones stadium warrington wolves 38 - 20 super league 2
2008-03-02 galpharm stadium huddersfield giants 28 - 8 super league 1
2008-03-07 knowsley road st helens rlfc 30 - 29 super league 1
2008-04-11 the jungle castleford tigers 12 - 32 super league 2
2008-04-27 kc stadium huddersfield giants 28 - 20 super league 1
2008-06-15 kc stadium castleford tigers 40 - 14 super league 3
2008-07-12 belle vue wakefield trinity wildcats 18 - 26 super league 2
2008-07-20 kc stadium hull kr 44 - 18 super league 1
2009-02-27 kc stadium catalans dragons 28 - 12 super league 1
2009-03-15 odsal bradford bulls 24 - 36 super league 2
2009-03-28 twickenham stoop harlequins rl 22 - 12 super league 1
2009-07-17 kc stadium crusaders 22 - 6 super league 1
2009-07-25 craven park hull kr 24 - 18 super league 4
2009-08-21 kc stadium harlequins rl 26 - 6 super league 3
2009-09-04 jjb stadium wigan warriors 34 - 22 super league 1
2010-02-12 kc stadium huddersfield giants 14 - 6 super league 1
2010-02-26 kc stadium harlequins rl 28 - 4 super league 1
2010-03-05 kc stadium castleford tigers 42 - 22 super league 1
2010-03-12 jjb stadium wigan warriors 48 - 24 super league 1
2010-04-05 kc stadium warrington wolves 10 - 29 super league 1
2010-04-11 headingley carnegie leeds rhinos 46 - 30 super league 1
2010-06-11 kc stadium salford city reds 34 - 12 super league 2
2010-07-04 odsal bradford bulls 22 - 28 super league 1
2011-03-07 the jungle castleford tigers 27 - 14 super league 1
2011-03-18 the willows salford city reds 34 - 18 super league 2
2011-06-12 headingley carnegie leeds rhinos 44 - 14 super league 1

Step 3: Select rows where the 'date' is '2009-03-28'.

SQL command for the step:

SELECT * FROM table_sql WHERE date = '2009-03-28';
date venue opponent result tournament scored
2007-04-06 twickenham stoop harlequins rl 30 - 28 super league 1
2009-03-28 twickenham stoop harlequins rl 22 - 12 super league 1

Step 4: Select rows where the 'result' is '22 - 12'.

SQL command for the step:

SELECT * FROM table_sql WHERE result = '22 - 12';
date venue opponent result tournament scored
2009-03-28 twickenham stoop harlequins rl 22 - 12 super league 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;
date venue opponent result tournament scored
2009-03-28 twickenham stoop harlequins rl 22 - 12 super league 1

Verification:

The statement is TRUE