Table: teen_age_message
Columns: hd_designation
constellation
distance_ly
spectral_type
signal_power_kw
date_sent
arrival_date

Question: If the distance is 55.7, what is the name of the constellation?
SQL: SELECT "constellation" FROM teen_age_message WHERE "distance_ly" = '55.7'

Question: If the spectral type is g1v, what is the total distance amount?
SQL: SELECT COUNT("distance_ly") FROM teen_age_message WHERE "spectral_type" = 'G1V'

Question: What is the hd designation for arrival date of February 2070?
SQL: SELECT COUNT("hd_designation") FROM teen_age_message WHERE "arrival_date" = 'February 2070'

Question: If the constellation is Gemini, what is the spectral type?
SQL: SELECT "spectral_type" FROM teen_age_message WHERE "constellation" = 'Gemini'

Question: If the arrival date is January 2059, what is the total amount of signal power?
SQL: SELECT COUNT("signal_power_kw") FROM teen_age_message WHERE "arrival_date" = 'January 2059'

Question: If the spectral type is g1v, what is the constellation?
SQL: SELECT "constellation" FROM teen_age_message WHERE "spectral_type" = 'G1V'