Table: uk_mp_records_2
Columns: rank_in_military
name
born
killed
political_party
mp_s_seat

Question: What was the military rank for the person killed in 1918, born after 1865, and has a MP's Seat in Edinburgh South?
SQL: SELECT "rank_in_military" FROM uk_mp_records_2 WHERE "killed" = 1918 AND "born" > 1865 AND "mp_s_seat" = 'edinburgh south'