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 one of the Ocarina songs learned by Adult Link from the windmill man. It can summon rain when the song is played, reveal secret grottoes and water bean sprouts to produce fairies. 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.

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.

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."

Trivia

 * A time paradox is created in Ocarina of Time: according to the Windmill Man, a child (assumed to be Young Link) played the Song of Storms to speed up the windmill, yet Link is taught the song by the Windmill Man. Because of this, it is not clear exactly how Link originally learned the song to have played it to the Windmill Man in the first place. However, the Windmill Man might somehow have the ability to exist outside of time for moments, therefore creating an effect similar to the Happy Mask Salesman in Majora's Mask. Another theory is that link didn't play it until after he learned it in the future. Thus explaining why link had no knowledge of the song as a child, and the day the windmill was ruined that guru guru was talking about, was the day when link went into the well.
 * The Song of Storms can be played to the Fabulous Five Froggish Tenors in Zora's River to gain a Piece of Heart. However, if the bug catching game is played before this, this piece of heart becomes unattainable.