Step 1: Select rows where 'status' is 'test match'.
| 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: Extract the month from the 'date' column to add column 'month' to existing table.
| opposing_team |
against |
date |
venue |
status |
| ireland |
6 |
1978-11-04 |
lansdowne road , dublin |
test match |
| wales |
12 |
1978-11-01 |
cardiff arms park , cardiff |
test match |
| england |
6 |
1978-11-25 |
twickenham , london |
test match |
| scotland |
9 |
1978-12-09 |
murrayfield , edinburgh |
test match |
Step 3: Extract the year from the 'date' column to add column 'year' to existing table.
| opposing_team |
against |
date |
venue |
status |
month |
| ireland |
6 |
1978-11-04 |
lansdowne road , dublin |
test match |
11 |
| wales |
12 |
1978-11-01 |
cardiff arms park , cardiff |
test match |
11 |
| england |
6 |
1978-11-25 |
twickenham , london |
test match |
11 |
| scotland |
9 |
1978-12-09 |
murrayfield , edinburgh |
test match |
12 |
Step 4: Select rows where 'month' is not 'october'.
| opposing_team |
against |
date |
venue |
status |
month |
year |
| ireland |
6 |
1978-11-04 |
lansdowne road , dublin |
test match |
11 |
1978 |
| wales |
12 |
1978-11-01 |
cardiff arms park , cardiff |
test match |
11 |
1978 |
| england |
6 |
1978-11-25 |
twickenham , london |
test match |
11 |
1978 |
| scotland |
9 |
1978-12-09 |
murrayfield , edinburgh |
test match |
12 |
1978 |
Step 5: Select rows where 'year' is not 1978.
| opposing_team |
against |
date |
venue |
status |
month |
year |
| ireland |
6 |
1978-11-04 |
lansdowne road , dublin |
test match |
11 |
1978 |
| wales |
12 |
1978-11-01 |
cardiff arms park , cardiff |
test match |
11 |
1978 |
| england |
6 |
1978-11-25 |
twickenham , london |
test match |
11 |
1978 |
| scotland |
9 |
1978-12-09 |
murrayfield , edinburgh |
test match |
12 |
1978 |
Step 6: Use a `CASE` statement to return TRUE if the number of rows is equal to 0, otherwise return FALSE.
| opposing_team |
against |
date |
venue |
status |
month |
year |
Prediction: TRUE