Table: blackberry_storm_data
Columns: device
carrier
package_version
applications
software_platform

Question: WHAT IS THE PACKAGE VERSION WITH TELUS MOBILITY?
SQL: SELECT "package_version" FROM blackberry_storm_data WHERE "carrier" = 'telus mobility'

Question: WHAT IS THE PACKAGE VERSION FOR blackberry storm 9530, APPLICATION 5.0.0.419, AND MTS MOBILITY?
SQL: SELECT "package_version" FROM blackberry_storm_data WHERE "device" = 'blackberry storm 9530' AND "applications" = '5.0.0.419' AND "carrier" = 'mts mobility'

Question: WHAT IS THE CARRIER WITH 5.0.0.742 VERSION?
SQL: SELECT "carrier" FROM blackberry_storm_data WHERE "package_version" = '5.0.0.742'

Question: WHAT IS THE CARRIER FOR 4.7.0.208 VERSION?
SQL: SELECT "carrier" FROM blackberry_storm_data WHERE "package_version" = '4.7.0.208'

Question: WHAT IS THE DEVICE WITH MTS MOBILITY?
SQL: SELECT "device" FROM blackberry_storm_data WHERE "carrier" = 'mts mobility'