Song of Storms

The "Song of Storms" is a song that has made several appearances in various Zelda games, making its debut in Ocarina of Time.

Ocarina of Time
In Ocarina of Time, the "Song of Storms" is the only non-warping Ocarina song learned by Adult Link. It is taught to him by the windmill man in Kakariko Village. It can summon rain when the song is played, reveal secret grottoes and water bean sprouts to produce fairies. In several areas throughout Hyrule, such as in the Lost Woods, if Navi turns green, Link can play the Song of Storms and a short cutscene showing a wingless fairy will begin. These fairies will restore Link's magic meter as well as his life energy but cannot be caught in a bottle. By playing the "Song of Storms" inside the windmill as a child, it will speed up the windmill dramatically, causing the well in Kakariko Village to empty.

Majora's Mask
The "Song of Storms" makes another appearance in Majora's Mask, where its origins are explained. The "Song of Storms" was a song composed by the Composer Brothers of the Ikana Canyon, specifically by Flat. When Link finds Flat's crypt beneath the Ikana Graveyard, Flat teaches it to him; it represents his sadness of losing Sharp, the other Composer Brother, and his anger for Sharp's betrayal. By playing the song in front of Sharp, Link manages to cure Sharp's soul, reviving the Ikana River in the process.

Playing the "Song of Storms" after getting cursed by a Blue Bubble immediately dispels the curse.

Oracle of Seasons
In Oracle of Seasons, the "Song of Storms" is the background music for the area around the windmill, east of the village in the Eastern Suburbs.It is played by Guru Guru on his phonograph

Super Smash Bros. Brawl
The "Song of Storms" also makes an appearance in Super Smash Bros. Brawl as a hidden song for the Pirate Ship stage. It is collaborated with Ganondorf's theme and the "Serenade of Water". Moreover, it is part of the "Ocarina of Time" medley, and it appears alongside other familiar melodies such as "Epona's Song", "Zelda's Lullaby", "Saria's Song", and the "Song of Time."

Music Theory
The Song of Storms is in triple time and features a 4-bar intro. The rest of the piece is 7 bars long and looped ad infinitum with the last bar of the 8-bar melodic phrase overlapping with the first bar of the intro (making a phrase analysis of 8 + 3 with the last bar of the 8 also acting as the 'real' first bar of the 3). Even though the piece is only 11 bars long, it uses two different sets of instrumentation to add variety. The first set primarily uses an organ for the melody while the second set uses an accordion and glockenspiel or celeste.

Harmonically, the piece is set in d Dorian with a brief use of B-flat Major.

Trivia

 * Despite playing the song constantly, the Windmill Man in describes young Link's version of it as a "strange song". Link's experience with the Song of Storms is actually part of a time loop; the Windmill Man teaches adult Link the melody because of his fury at the damage young Link wrought by playing it, and after traveling back in time, young Link uses that knowledge just as the Windmill Man described, causing the damage that led to his fury. This makes Link learning the song an example of a, as Link could not have learned the song if he hadn't gone on to play it in the Windmill Man's past.
 * The Song of Storms can be played to the Fabulous Five Froggish Tenors in Zora's River to gain a Piece of Heart.
 * This is the only non-warping song learned by link as an adult in.