Step 1: Select rows where 'venue' is 'twickenham , london'.
opposing_team |
against |
date |
venue |
status |
cambridge university |
12 |
1978-10-18 |
grange road , cambridge |
tour match |
cardiff |
7 |
1978-10-21 |
cardiff arms park , cardiff |
tour match |
west wales xv |
7 |
1978-10-25 |
st helen 's , swansea |
tour match |
london counties |
12 |
1978-10-28 |
twickenham , london |
tour match |
munster |
12 |
1978-10-31 |
thomond park , limerick |
tour match |
ireland |
6 |
1978-11-04 |
lansdowne road , dublin |
test match |
ulster |
7 |
1978-11-07 |
ravenhill , belfast |
tour match |
wales |
12 |
1978-11-01 |
cardiff arms park , cardiff |
test match |
south and south - west counties |
0 |
1978-11-15 |
memorial ground , bristol |
tour match |
midland counties |
15 |
1978-11-18 |
welford road , leicester |
tour match |
combined services |
6 |
1978-11-21 |
aldershot military stadium , aldershot |
tour match |
england |
6 |
1978-11-25 |
twickenham , london |
test match |
monmouthshire |
9 |
1978-11-29 |
rodney parade , newport |
tour match |
north of england |
6 |
1978-12-02 |
birkenhead park , birkenhead |
tour match |
north and midland of scotland |
3 |
1978-12-05 |
linksfield stadium , aberdeen |
tour match |
scotland |
9 |
1978-12-09 |
murrayfield , edinburgh |
test match |
bridgend |
6 |
1978-12-13 |
brewery field , bridgend |
tour match |
barbarians |
16 |
1978-12-16 |
cardiff arms park , cardiff |
tour match |
Step 2: Select rows where 'date' is in the month of November.
opposing_team |
against |
date |
venue |
status |
london counties |
12 |
1978-10-28 |
twickenham , london |
tour match |
england |
6 |
1978-11-25 |
twickenham , london |
test match |
Step 3: Select rows where 'status' is 'tour match'.
opposing_team |
against |
date |
venue |
status |
england |
6 |
1978-11-25 |
twickenham , london |
test match |
Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to the number of rows in the previous step, otherwise return FALSE.
opposing_team |
against |
date |
venue |
status |
Prediction: TRUE
Ground-truth: FALSE