Statement: windows live messenger version 14 and made by microsoft was relased on 2010 - 11 - 17 under the category of social networking
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 (SELECT COUNT(*) FROM table_sql WHERE title = 'windows live messenger' AND version = '1.4' AND developer = 'microsoft' AND release_date = '2010-11-17' AND category = 'social networking') > 0
THEN 'TRUE'
ELSE 'FALSE'
END;