Asosiy matnga o'tish

78. Takrorlangan email larni topish

O'rtacha

Import faylida bir xil email bir necha marta uchragan.

CTE da takrorlangan email larni aniqlang, so'ng ularning barcha yozuvlarini

chiqaring.

Ustunlar: email, full_name, dup_count — bu email nechta yozuvda uchraydi.

Saralash: dup_count kamayish, keyin email alifbo, keyin full_name.

Jadval: contacts

UstunTuri
idINT PK
emailVARCHAR
full_nameVARCHAR

Namuna ma'lumotlar

sample
contacts
idINTemailVARCHAR(80)full_nameVARCHAR(60)
1aziz@mail.uzAziz K
2aziz@mail.uzAziz Karimov
3nilufar@mail.uzNilufar R
Kutilgan natija
emaildup_countfull_name
aziz@mail.uz2Aziz K
aziz@mail.uz2Aziz Karimov
sample-full
contacts
idINTemailVARCHAR(80)full_nameVARCHAR(60)
1aziz@mail.uzAziz K
2aziz@mail.uzAziz Karimov
3nilufar@mail.uzNilufar R
4bekzod@mail.uzBekzod T
5aziz@mail.uzA. Karimov
6bekzod@mail.uzBekzod Tursunov
7malika@mail.uzMalika Y
8nilufar@mail.uzN. Rahimova
9sardor@mail.uzSardor N
10jasur@mail.uzJasur Q
11malika@mail.uzMalika Yusupova
12nilufar@mail.uzNilufar Rahimova
Kutilgan natija
emaildup_countfull_name
aziz@mail.uz3A. Karimov
aziz@mail.uz3Aziz K
aziz@mail.uz3Aziz Karimov
nilufar@mail.uz3N. Rahimova
nilufar@mail.uz3Nilufar R
nilufar@mail.uz3Nilufar Rahimova
bekzod@mail.uz2Bekzod T
bekzod@mail.uz2Bekzod Tursunov
malika@mail.uz2Malika Y
malika@mail.uz2Malika Yusupova
sample-extra
contacts
idINTemailVARCHAR(80)full_nameVARCHAR(60)
5sardor233@mail.uzN. Rahimova
4javohir379@mail.uzAziz Karimov
3sardor233@mail.uzA. Karimov
2aziz892@mail.uzSardor N
1islom264@mail.uzNilufar R
Kutilgan natija
emaildup_countfull_name
sardor233@mail.uz2A. Karimov
sardor233@mail.uz2N. Rahimova

O'xshash masalalar

Konsol

Natijani ko'rish uchun so'rovni ishga tushiring.