Step 1: Select rows where 'title' is 'spy vs spy'.
title |
genre |
c___64 |
zx_spectrum |
others |
year |
format |
goodness gracious |
arcade |
c64 |
n / a |
n / a |
1983-01-01 |
tape |
kriegspiel |
strategy |
n / a |
n / a |
dragon 32 |
1983-01-01 |
tape |
space station zebra |
arcade |
n / a |
zx spectrum |
n / a |
1983-01-01 |
tape |
up periscope |
strategy |
n / a |
n / a |
dragon 32 |
1983-01-01 |
tape |
ankh |
puzzle |
c64 |
n / a |
n / a |
1984-01-01 |
tape |
aztec |
arcade |
c64 |
n / a |
n / a |
1984-01-01 |
tape |
lords of midnight |
graphic adventure |
c64 |
zx spectrum |
amstrad cpc |
1984-01-01 |
tape , disk |
mr robot |
arcade |
c64 |
n / a |
n / a |
1984-01-01 |
tape |
my chess ii |
board game |
c64 |
n / a |
n / a |
1984-01-01 |
tape , disk |
psytron |
tactical combat |
c64 |
zx spectrum |
n / a |
1984-01-01 |
tape |
spellbound |
arcade |
n / a |
zx spectrum |
n / a |
1984-01-01 |
tape |
spy vs spy |
arcade |
c64 |
zx spectrum |
amstrad cpc |
1984-01-01 |
tape |
bounces |
arcade |
c64 |
zx spectrum |
n / a |
1985-01-01 |
tape |
doomdark 's revenge |
graphic adventure |
c64 |
zx spectrum |
amstrad cpc |
1985-01-01 |
tape |
psi warrior |
arcade |
c64 |
n / a |
n / a |
1985-01-01 |
tape |
shadowfire |
tactical combat |
c64 |
zx spectrum |
amstrad cpc |
1985-01-01 |
tape |
shadowfire tuner |
game editor |
c64 |
zx spectrum |
n / a |
1985-01-01 |
tape |
sorderon 's shadow |
graphic adventure |
n / a |
zx spectrum |
n / a |
1985-01-01 |
tape |
quake minus one |
rts |
c64 |
n / a |
n / a |
1985-01-01 |
tape |
superman : the game |
arcade / strategy |
c64 |
n / a |
n / a |
1985-01-01 |
tape |
enigma force |
tactical combat |
c64 |
zx spectrum |
n / a |
1986-01-01 |
tape |
dante 's inferno |
arcade adventure |
c64 |
n / a |
n / a |
1986-01-01 |
tape |
infodroid |
arcade |
c64 |
n / a |
n / a |
1986-01-01 |
tape |
romper room |
educational |
c64 |
zx spectrum |
n / a |
1986-01-01 |
tape |
Step 2: Select rows where 'genre' is 'arcade'.
title |
genre |
c___64 |
zx_spectrum |
others |
year |
format |
spy vs spy |
arcade |
c64 |
zx spectrum |
amstrad cpc |
1984-01-01 |
tape |
Step 3: Select rows where 'dragon 32' is not 'n/a'.
title |
genre |
c___64 |
zx_spectrum |
others |
year |
format |
spy vs spy |
arcade |
c64 |
zx spectrum |
amstrad cpc |
1984-01-01 |
tape |
Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
title |
genre |
c___64 |
zx_spectrum |
others |
year |
format |
spy vs spy |
arcade |
c64 |
zx spectrum |
amstrad cpc |
1984-01-01 |
tape |