Table: shortest_reigns
Columns: name
country
reign_began
reign_ended
length

Question: Whose reign ended in Egypt?
SQL: SELECT "reign_ended" FROM shortest_reigns WHERE "country" = 'egypt'

Question: Whose reign ended in Afghanistan after 3 days?
SQL: SELECT "reign_ended" FROM shortest_reigns WHERE "length" = '3 days' AND "country" = 'afghanistan'

Question: Whose reign began in Vietnam and ended in October 1005?
SQL: SELECT "reign_began" FROM shortest_reigns WHERE "country" = 'vietnam' AND "reign_ended" = 'october 1005'

Question: When did Pharaoh Seth's reign end?
SQL: SELECT "reign_ended" FROM shortest_reigns WHERE "name" = 'pharaoh seth'