Sayyiduna Umar (may Allah be pleased with him) said that when the prohibition of wine was revealed, Sayyiduna Umar (may Allah be pleased with him) supplicated to Allah Almighty: 'Allahumma bayyin lana fi al-khamri bayanan shafiyan' (O Allah, give us a satisfying explanation regarding wine). Then this verse was revealed: "They ask you about wine and gambling" [Surah al-Baqarah: 219]. Then Sayyiduna Umar (may Allah be pleased with him) supplicated as before, and "O you who believe, do not approach prayer while you are intoxicated" [Surah al-Nisa': 43] was revealed. Then Sayyiduna Umar (may Allah be pleased with him) made the same supplication, and "So will you not desist?" [Surah al-Ma'idah: 91] was revealed. Sayyiduna Umar (may Allah be pleased with him) said: "We have desisted."
Hadith Referenceالسنن الكبرى للبيهقي / كتاب الأشربة والحد فيها / 17324