Asosiy matnga o'tish

186. Eng uzun g'alabalar seriyasi

Qiyin

Har bir jamoa uchun ketma-ket qo'lga kiritilgan g'alabalarning eng uzun

seriyasi uzunligini toping.

Faqat WIN natijalari seriyani davom ettiradi; DRAW yoki LOSS uni

uzadi.

Hech qachon yutmagan jamoa uchun 0 chiqishi kerak — u natijadan

tushib qolmasin.

Bu ham "gaps & islands": g'alabalarni oroliga ajratib, eng kattasini oling.

Ustunlar: team, longest_streak.

Saralash: longest_streak kamayish, keyin team alifbo.

matches: id INT PK, team VARCHAR, played_on DATE, result VARCHAR

Namuna ma'lumotlar

sample
matches
idINTteamVARCHAR(30)played_onDATEresultVARCHAR(5)
1Pakhtakor2025-03-01WIN
2Pakhtakor2025-03-08WIN
3Pakhtakor2025-03-15DRAW
11Bunyodkor2025-03-01LOSS
Kutilgan natija
teamlongest_streak
Pakhtakor2
Bunyodkor0
sample-full
matches
idINTteamVARCHAR(30)played_onDATEresultVARCHAR(5)
1Pakhtakor2025-03-01WIN
2Pakhtakor2025-03-08WIN
3Pakhtakor2025-03-15DRAW
4Pakhtakor2025-03-22WIN
5Pakhtakor2025-03-29WIN
6Pakhtakor2025-04-05WIN
7Nasaf2025-03-01LOSS
8Nasaf2025-03-08WIN
9Nasaf2025-03-15LOSS
10Nasaf2025-03-22WIN
11Bunyodkor2025-03-01LOSS
12Bunyodkor2025-03-08DRAW
13Bunyodkor2025-03-15LOSS
14Navbahor2025-03-01WIN
15Navbahor2025-03-08WIN
16Navbahor2025-03-15WIN
17Navbahor2025-03-22WIN
Kutilgan natija
teamlongest_streak
Navbahor4
Pakhtakor3
Nasaf1
Bunyodkor0
sample-extra
matches
idINTteamVARCHAR(30)played_onDATEresultVARCHAR(5)
1Bunyodkor2025-02-26WIN
2Bunyodkor2025-02-26WIN
3Pakhtakor2025-03-01WIN
4Nasaf2025-03-09WIN
Kutilgan natija
teamlongest_streak
Bunyodkor2
Nasaf1
Pakhtakor1

O'xshash masalalar

Konsol

Natijani ko'rish uchun so'rovni ishga tushiring.