5. Har kategoriyada top 3 mahsulot
O'rtachaproducts (id, name, category, sales) jadvali mahsulotlar va ularning savdo hajmini saqlaydi.
Vazifa: har kategoriyada savdo hajmi bo'yicha eng yuqori 3 o'rindagi mahsulotlarni qaytaring (DENSE_RANK — teng savdolar bir o'rinni egallaydi). Natija ustunlari: category, product, sales. Tartib: category (A→Z), keyin sales (kamayish), keyin product (A→Z).
Jadval: products
| Ustun | Turi |
|---|---|
| id | INT PK |
| name | VARCHAR(50) |
| category | VARCHAR(30) |
| sales | INT |
Namuna ma'lumotlar
sample-main
products
| idINT | nameVARCHAR(50) | categoryVARCHAR(30) | salesINT |
|---|---|---|---|
| 1 | A | Phone | 500 |
| 2 | B | Phone | 300 |
| 3 | C | Phone | 200 |
| 4 | D | Phone | 100 |
| 5 | E | Laptop | 900 |
| 6 | F | Laptop | 800 |
Kutilgan natija
| sales | product | category |
|---|---|---|
| 900 | E | Laptop |
| 800 | F | Laptop |
| 500 | A | Phone |
| 300 | B | Phone |
| 200 | C | Phone |
sample-fewer
products
| idINT | nameVARCHAR(50) | categoryVARCHAR(30) | salesINT |
|---|---|---|---|
| 1 | A | Book | 50 |
| 2 | B | Book | 30 |
Kutilgan natija
| sales | product | category |
|---|---|---|
| 50 | A | Book |
| 30 | B | Book |
sample-tie
products
| idINT | nameVARCHAR(50) | categoryVARCHAR(30) | salesINT |
|---|---|---|---|
| 1 | A | TV | 100 |
| 2 | B | TV | 100 |
| 3 | C | TV | 90 |
| 4 | D | TV | 80 |
| 5 | E | TV | 70 |
Kutilgan natija
| sales | product | category |
|---|---|---|
| 100 | A | TV |
| 100 | B | TV |
| 90 | C | TV |
| 80 | D | TV |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.