186. Eng uzun g'alabalar seriyasi
QiyinHar 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
| idINT | teamVARCHAR(30) | played_onDATE | resultVARCHAR(5) |
|---|---|---|---|
| 1 | Pakhtakor | 2025-03-01 | WIN |
| 2 | Pakhtakor | 2025-03-08 | WIN |
| 3 | Pakhtakor | 2025-03-15 | DRAW |
| 11 | Bunyodkor | 2025-03-01 | LOSS |
Kutilgan natija
| team | longest_streak |
|---|---|
| Pakhtakor | 2 |
| Bunyodkor | 0 |
sample-full
matches
| idINT | teamVARCHAR(30) | played_onDATE | resultVARCHAR(5) |
|---|---|---|---|
| 1 | Pakhtakor | 2025-03-01 | WIN |
| 2 | Pakhtakor | 2025-03-08 | WIN |
| 3 | Pakhtakor | 2025-03-15 | DRAW |
| 4 | Pakhtakor | 2025-03-22 | WIN |
| 5 | Pakhtakor | 2025-03-29 | WIN |
| 6 | Pakhtakor | 2025-04-05 | WIN |
| 7 | Nasaf | 2025-03-01 | LOSS |
| 8 | Nasaf | 2025-03-08 | WIN |
| 9 | Nasaf | 2025-03-15 | LOSS |
| 10 | Nasaf | 2025-03-22 | WIN |
| 11 | Bunyodkor | 2025-03-01 | LOSS |
| 12 | Bunyodkor | 2025-03-08 | DRAW |
| 13 | Bunyodkor | 2025-03-15 | LOSS |
| 14 | Navbahor | 2025-03-01 | WIN |
| 15 | Navbahor | 2025-03-08 | WIN |
| 16 | Navbahor | 2025-03-15 | WIN |
| 17 | Navbahor | 2025-03-22 | WIN |
Kutilgan natija
| team | longest_streak |
|---|---|
| Navbahor | 4 |
| Pakhtakor | 3 |
| Nasaf | 1 |
| Bunyodkor | 0 |
sample-extra
matches
| idINT | teamVARCHAR(30) | played_onDATE | resultVARCHAR(5) |
|---|---|---|---|
| 1 | Bunyodkor | 2025-02-26 | WIN |
| 2 | Bunyodkor | 2025-02-26 | WIN |
| 3 | Pakhtakor | 2025-03-01 | WIN |
| 4 | Nasaf | 2025-03-09 | WIN |
Kutilgan natija
| team | longest_streak |
|---|---|
| Bunyodkor | 2 |
| Nasaf | 1 |
| Pakhtakor | 1 |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.
