2. Har bo'limdagi eng yuqori maosh
O'rtachadepartment (id, name) va employee (id, name, salary, department_id) jadvallari berilgan.
Vazifa: har bo'limdagi eng yuqori maosh oluvchi xodim(lar)ni toping. Natija ustunlari: department, employee, salary. Agar bo'limda bir nechta xodim eng yuqori maoshga ega bo'lsa, hammasini qaytaring.
Jadval: department
| Ustun | Turi |
|---|---|
| id | INT PK |
| name | VARCHAR(50) |
Jadval: employee
| Ustun | Turi |
|---|---|
| id | INT PK |
| name | VARCHAR(50) |
| salary | INT |
| department_id | INT |
Namuna ma'lumotlar
sample-main
department
| idINT | nameVARCHAR(50) |
|---|---|
| 1 | IT |
| 2 | Sales |
employee
| idINT | nameVARCHAR(50) | salaryINT | department_idINT |
|---|---|---|---|
| 1 | Aziz | 9000000 | 1 |
| 2 | Bek | 11000000 | 1 |
| 3 | Dild | 7000000 | 2 |
| 4 | Elyor | 7000000 | 2 |
Kutilgan natija
| salary | employee | department |
|---|---|---|
| 11000000 | Bek | IT |
| 7000000 | Dild | Sales |
| 7000000 | Elyor | Sales |
sample-single
department
| idINT | nameVARCHAR(50) |
|---|---|
| 1 | HR |
employee
| idINT | nameVARCHAR(50) | salaryINT | department_idINT |
|---|---|---|---|
| 1 | Solo | 4200000 | 1 |
Kutilgan natija
| salary | employee | department |
|---|---|---|
| 4200000 | Solo | HR |
sample-tie
department
| idINT | nameVARCHAR(50) |
|---|---|
| 1 | Dev |
employee
| idINT | nameVARCHAR(50) | salaryINT | department_idINT |
|---|---|---|---|
| 1 | A | 10000000 | 1 |
| 2 | B | 10000000 | 1 |
| 3 | C | 8000000 | 1 |
Kutilgan natija
| salary | employee | department |
|---|---|---|
| 10000000 | A | Dev |
| 10000000 | B | Dev |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.