Statement: 2010 - 11 - 17 is the release date of version 1.0 with a category of utilities , a developer of dino games , and a title of msn money
Input Table: list of zune applications
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 |
SQL Command:
SELECT
CASE
WHEN COUNT(*) = 0 THEN 'FALSE'
ELSE 'TRUE'
END
FROM table_sql
WHERE release_date = '2010-11-17'
AND version = '1.0'
AND category = 'utilities'
AND developer = 'dino games'
AND title = 'msn money';