Table: mobile_os_sales
Columns: quarter
android
ios
symbian
blackberry_os
linux
windows_phone
other
total

Question: During the quarter of 2012 Q2, how many millions of Blackberry OS phones where shipped when 0.1 million others were shipped?
SQL: SELECT COUNT("blackberry_os") FROM mobile_os_sales WHERE "other" = '0.1' AND "quarter" = '2012 Q2'

Question: During the quarter 2012 Q4, how many millions of android phones were shipped?
SQL: SELECT COUNT("android") FROM mobile_os_sales WHERE "quarter" = '2012 Q4'

Question: How many million of windows phones were shipped during the quarter that shipped 216.2 million total?
SQL: SELECT "windows_phone" FROM mobile_os_sales WHERE "total" = '216.2'

Question: How many total smartphones were shipped during the quarter 2012 Q1?
SQL: SELECT COUNT("total") FROM mobile_os_sales WHERE "quarter" = '2012 Q1'

Question: How many millions of Blackberry OS smartphones were shipped when 10.4 million Symbian smartphones were shipped?
SQL: SELECT "blackberry_os" FROM mobile_os_sales WHERE "symbian" = '10.4'

Question: How man "other" millions of smartphones were shipped when 181.1 million total were shipped?
SQL: SELECT COUNT("other") FROM mobile_os_sales WHERE "total" = '181.1'