Step 1: Select rows where 'developer' is 'babaroga'.
title |
developer |
category |
release_date |
version |
alarm clock |
microsoft |
utilities |
2010-12-16 |
1.1 |
calculator |
microsoft |
utilities |
2009-09-01 |
1.0 |
calendar |
matchbox |
utilities |
2011-07-29 |
1.0.0.3 |
chord finder |
microsoft |
utilities |
2010-11-17 |
1.0 |
drum machine hd |
dino games |
utilities |
2010-10-20 |
1.0 |
email |
microsoft |
utilities |
2011-04-01 |
1.1.0.1 |
facebook |
matchbox |
social networking |
2010-12-16 |
1.4 |
fan prediction |
ihwy , inc |
entertainment |
2011-06-23 |
1.0 |
fingerpaint |
babaroga |
entertainment |
2011-07-29 |
1.1 |
level |
microsoft |
utilities |
2011-06-23 |
1.0 |
metronome |
dino games |
utilities |
2010-09-09 |
1.0 |
msn money |
microsoft |
utilities |
2010-07-29 |
1.0 |
notes |
microsoft |
utilities |
2011-06-23 |
1.0 |
piano |
microsoft |
entertainment |
2009-11-01 |
1.0 |
shuffle by album |
microsoft |
utilities |
2011-02-18 |
1.1 |
stopwatch |
microsoft |
utilities |
2010-08-05 |
1.1 |
twitter |
matchbox |
social networking |
2010-12-16 |
1.6 |
weather |
microsoft |
utilities |
2009-09-01 |
1.0 |
windows live messenger |
microsoft |
social networking |
2010-11-17 |
1.4 |
zune reader |
microsoft |
utilities |
2011-02-18 |
1.2 |
Step 2: Select rows where 'release_date' is '2010-12-16'.
title |
developer |
category |
release_date |
version |
fingerpaint |
babaroga |
entertainment |
2011-07-29 |
1.1 |
Step 3: Select rows where 'title' is 'facebook'.
title |
developer |
category |
release_date |
version |
Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
title |
developer |
category |
release_date |
version |