Step 1: Select rows where 'lifetime_achievement' is not 'na'.
| year |
best_teenage___young_adult |
reader__s_vote |
best_non___fiction |
lifetime_achievement |
| 1996-01-01 |
na |
na |
na |
jon cleary |
| 1997-01-01 |
na |
na |
how to write crime edited by marele day |
alan yates (aka carter brown ) |
| 1998-01-01 |
na |
na |
na |
na |
| 1999-01-01 |
na |
na |
na |
peter corris |
| 2000-01-01 |
na |
na |
na |
na |
| 2001-01-01 |
na |
bleeding hearts by lindy cameron |
na |
professor stephen knight |
| 2002-01-01 |
blue murder by ken catran |
apartment 255 by bunty avieson |
na |
patrick gallagher |
| 2003-01-01 |
na |
na |
na |
kerry greenwood |
| 2004-01-01 |
na |
na |
na |
bob bottom |
| 2005-01-01 |
na |
na |
na |
stuart coupe |
| 2006-01-01 |
na |
na |
na |
andrew rule and john silvester |
| 2007-01-01 |
na |
na |
na |
sandra harvey and lindsay simpson |
| 2008-01-01 |
na |
na |
na |
marele day |
| 2009-01-01 |
na |
na |
na |
shane maloney |
| 2010-01-01 |
na |
na |
na |
peter doyle |
| 2011-01-01 |
na |
na |
na |
na |
Step 2: Select rows where 'year' is after 1998.
| year |
best_teenage___young_adult |
reader__s_vote |
best_non___fiction |
lifetime_achievement |
| 1996-01-01 |
na |
na |
na |
jon cleary |
| 1997-01-01 |
na |
na |
how to write crime edited by marele day |
alan yates (aka carter brown ) |
| 1999-01-01 |
na |
na |
na |
peter corris |
| 2001-01-01 |
na |
bleeding hearts by lindy cameron |
na |
professor stephen knight |
| 2002-01-01 |
blue murder by ken catran |
apartment 255 by bunty avieson |
na |
patrick gallagher |
| 2003-01-01 |
na |
na |
na |
kerry greenwood |
| 2004-01-01 |
na |
na |
na |
bob bottom |
| 2005-01-01 |
na |
na |
na |
stuart coupe |
| 2006-01-01 |
na |
na |
na |
andrew rule and john silvester |
| 2007-01-01 |
na |
na |
na |
sandra harvey and lindsay simpson |
| 2008-01-01 |
na |
na |
na |
marele day |
| 2009-01-01 |
na |
na |
na |
shane maloney |
| 2010-01-01 |
na |
na |
na |
peter doyle |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is greater than 0, otherwise return FALSE.
| year |
best_teenage___young_adult |
reader__s_vote |
best_non___fiction |
lifetime_achievement |
| 1999-01-01 |
na |
na |
na |
peter corris |
| 2001-01-01 |
na |
bleeding hearts by lindy cameron |
na |
professor stephen knight |
| 2002-01-01 |
blue murder by ken catran |
apartment 255 by bunty avieson |
na |
patrick gallagher |
| 2003-01-01 |
na |
na |
na |
kerry greenwood |
| 2004-01-01 |
na |
na |
na |
bob bottom |
| 2005-01-01 |
na |
na |
na |
stuart coupe |
| 2006-01-01 |
na |
na |
na |
andrew rule and john silvester |
| 2007-01-01 |
na |
na |
na |
sandra harvey and lindsay simpson |
| 2008-01-01 |
na |
na |
na |
marele day |
| 2009-01-01 |
na |
na |
na |
shane maloney |
| 2010-01-01 |
na |
na |
na |
peter doyle |
Prediction: TRUE
Ground-truth: FALSE