Table: military_ranks
Columns: equivalent_nato_rank_code
rank_in_spanish
rank_in_english
commonwealth_equivalent
us_air_force_equivalent

Question:  What could a spanish coronel be addressed as in the commonwealth military?
SQL: SELECT "commonwealth_equivalent" FROM military_ranks WHERE "rank_in_spanish" = 'Coronel'

Question: Give me a list of all spanish officer titles that could receive recognition as group captain in english
SQL: SELECT "rank_in_english" FROM military_ranks WHERE "commonwealth_equivalent" = 'Group Captain'

Question: If you are a pilot officer in the commonwealth then what will you called as in the US air force?
SQL: SELECT "us_air_force_equivalent" FROM military_ranks WHERE "commonwealth_equivalent" = 'Pilot Officer'

Question: If you're a major general in the US air force then what ranking will you receive in the commonwealth's air force?
SQL: SELECT "commonwealth_equivalent" FROM military_ranks WHERE "us_air_force_equivalent" = 'Major General'

Question: If you get a ranking as major in the  english military then what would the spanish military address you as? 
SQL: SELECT "rank_in_spanish" FROM military_ranks WHERE "rank_in_english" = 'Major'