Har bir bo‘limda eng katta maosh oladigan xodim(lar)ni toping: bo‘lim nomi, xodim ismi va maoshi. Bo‘limda eng katta maoshni bir nechta xodim olsa, hammasini chiqaring.
Namunaviy ma‘lumotlar
| id integer | name text |
|---|---|
| 1 | IT |
| 2 | Moliya |
| 3 | Marketing |
| id integer | name text | department_id integer | manager_id integer | salary integer | hire_date text |
|---|---|---|---|---|---|
| 1 | Hamid Toshmatov | 1 | NULL | 17500000 | 2018-12-11 |
| 2 | Alisher Aliyev | 2 | NULL | 16500000 | 2025-08-19 |
| 3 | Hamid Nazarov | 3 | NULL | 12000000 | 2022-12-15 |
| 4 | Bekzod Toshmatov | 1 | 1 | 4500000 | 2025-10-14 |
| 5 | Madina Umarov | 2 | 2 | 15000000 | 2018-03-03 |
| 6 | Laylo Karimov | 3 | 3 | 4500000 | 2022-03-08 |
| 7 | Madina Yusupov | 1 | 1 | 18500000 | 2023-11-23 |
| 8 | Anvar Sobirov | 2 | 2 | 11500000 | 2024-08-20 |
| 9 | Shahzod Toshmatov | 3 | 3 | 14000000 | 2023-07-26 |
| 10 | Laylo Umarov | 1 | 1 | 18500000 | 2024-06-09 |
| 11 | Bekzod Aliyev | 2 | 2 | 4500000 | 2025-10-27 |
Jadval tuzilishi (CREATE TABLE)
CREATE TABLE departments (id INTEGER PRIMARY KEY, name TEXT); CREATE TABLE employees (id INTEGER PRIMARY KEY, name TEXT, department_id INTEGER, manager_id INTEGER, salary INTEGER, hire_date TEXT);
Natija
Uch ustun: department, employee, salary.
Namunaviy ma‘lumotlarda kutilgan natija
| Moliya | Alisher Aliyev | 16500000 |
| IT | Madina Yusupov | 18500000 |
| Marketing | Shahzod Toshmatov | 14000000 |
| IT | Laylo Umarov | 18500000 |
Qatorlar tartibi ahamiyatsiz, ustunlar tartibi muhim. Yechim yashirin, kattaroq ma‘lumotlarda ham tekshiriladi.