Nobuo Uematsu wrote the music for the Final Fantasy games from the first one, on the NES in 1987. Two of his pieces come back in game after game: the Prelude, a harp arpeggio that rises and falls, and the Victory Fanfare that plays after a battle.
Aerith's Theme is from Final Fantasy VII and Melodies of Life is the theme song of Final Fantasy IX. Both are slow, singable melodies that sit well on an ocarina.