Plan-of-SQLs (Ours)


Statement: melbourne tigers have the same home record as south dragons

Ground-truth: FALSE

Input Table: 2008 - 09 nbl season

Step 1: Select rows where 'team' is 'melbourne tigers'.
team lost last_5 streak home away pts won
south dragons 8 4 - 1 won 2 13 - 2 9 - 6 110.25 73.33
melbourne tigers 10 3 - 2 lost 1 11 - 4 9 - 6 106.47 66.67
new zealand breakers 12 2 - 3 won 2 10 - 5 8 - 7 106.08 60.0
perth wildcats 13 4 - 1 won 2 11 - 4 6 - 9 102.06 56.67
townsville crocodiles 13 4 - 1 lost 1 12 - 3 5 - 10 99.26 56.67
adelaide 36ers 15 3 - 2 lost 1 12 - 3 3 - 12 100.92 50.0
wollongong hawks 19 2 - 3 lost 1 9 - 6 2 - 13 95.03 36.67
sydney spirit 19 0 - 5 lost 8 9 - 6 2 - 13 94.51 36.67
cairns taipans 19 1 - 4 lost 3 5 - 10 6 - 9 93.57 36.67
gold coast blaze 22 3 - 2 won 3 6 - 9 2 - 13 93.45 26.67

Step 2: Select rows where 'home' is the same as the 'home' record of 'south dragons'.
team lost last_5 streak home away pts won
melbourne tigers 10 3 - 2 lost 1 11 - 4 9 - 6 106.47 66.67

Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to the number of rows in the 'south dragons' record, otherwise return FALSE.
team lost last_5 streak home away pts won

Final output table:
verification_result
TRUE

Prediction: TRUE

Ground-truth: FALSE