Statement: twitter has the version of 1.0.0.3
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 version FROM table_sql WHERE title = 'twitter') = '1.0.0.3'
THEN 'TRUE'
ELSE 'FALSE'
END;