Step 1: Select rows where 'artist' is 'john mardon'.
year |
theme |
artist |
mintage |
issue_price |
2000 |
steam buggy |
john mardon |
44367 |
59.95 |
2000 |
the bluenose |
j franklin wright |
included in steam buggy |
59.95 |
2000 |
the toronto |
john mardon |
included in steam buggy |
59.95 |
2001 |
the russell light four |
john mardon |
41828 |
59.95 |
2001 |
the marco polo |
j franklin wright |
included in the russell |
59.95 |
2001 |
the scotia |
don curley |
included in the russell |
59.95 |
2002 |
the gray - dort |
john mardon |
35944 |
59.95 |
2002 |
the william lawrence |
bonnie ross |
included in the gray - dort |
59.95 |
2002 |
d - 10 locomotive |
dan fell |
included in the gray - dort |
59.95 |
2003 |
hmcs bras dor |
don curley |
31997 |
59.95 |
2003 |
cnr fa - 1 diesel electric |
john mardon |
included in hmcs bras dor |
59.95 |
2003 |
bricklin sv - 1 |
brian hughes |
included in hmcs bras dor |
59.95 |
Step 2: Select rows where 'theme' is 'steam buggy'.
year |
theme |
artist |
mintage |
issue_price |
2000 |
steam buggy |
john mardon |
44367 |
59.95 |
2000 |
the toronto |
john mardon |
included in steam buggy |
59.95 |
2001 |
the russell light four |
john mardon |
41828 |
59.95 |
2002 |
the gray - dort |
john mardon |
35944 |
59.95 |
2003 |
cnr fa - 1 diesel electric |
john mardon |
included in hmcs bras dor |
59.95 |
Step 3: Select rows where 'mintage' is not equal to 'included in steam buggy'.
year |
theme |
artist |
mintage |
issue_price |
2000 |
steam buggy |
john mardon |
44367 |
59.95 |
Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
year |
theme |
artist |
mintage |
issue_price |
2000 |
steam buggy |
john mardon |
44367 |
59.95 |
Prediction: TRUE