6. Rahbaridan ko'p maosh oladigan xodimlar
Osonstaff (id, name, salary, manager_id) jadvali xodimlarni saqlaydi. manager_id — o'sha xodimning rahbari (staff.id ga havola); rahbarsiz xodimda NULL.
Vazifa: o'z rahbaridan yuqori maosh oladigan xodimlarning ismini qaytaring. Natija ustuni: employee, employee bo'yicha o'sish tartibida.
Jadval: staff
| Ustun | Turi |
|---|---|
| id | INT PK |
| name | VARCHAR(50) |
| salary | INT |
| manager_id | INT |
Namuna ma'lumotlar
sample-main
staff
| idINT | nameVARCHAR(50) | salaryINT | manager_idINT |
|---|---|---|---|
| 1 | Rustam | 12000000 | NULL |
| 2 | Sardor | 13000000 | 1 |
| 3 | Malika | 5000000 | 1 |
Kutilgan natija
| employee |
|---|
| Sardor |
sample-none
staff
| idINT | nameVARCHAR(50) | salaryINT | manager_idINT |
|---|---|---|---|
| 1 | A | 9000000 | NULL |
| 2 | B | 8000000 | 1 |
| 3 | C | 7000000 | 2 |
sample-chain
staff
| idINT | nameVARCHAR(50) | salaryINT | manager_idINT |
|---|---|---|---|
| 1 | M1 | 10000000 | NULL |
| 2 | M2 | 11000000 | 1 |
| 3 | M3 | 9000000 | 2 |
Kutilgan natija
| employee |
|---|
| M2 |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.