Did the person who wrote words to The Star Spangled Banner also write melody song?

The answer is no.

The lyrics to The Star-Spangled Banner were written by Francis Scott Key in 1814, during the War of 1812. The melody of the song was composed by John Stafford Smith in 1778, and was originally a British drinking song called "To Anacreon in Heaven".