Maoshi kompaniya bo‘yicha o‘rtacha maoshdan katta bo‘lgan xodimlarning ismi va maoshini chiqaring.
O‘rtacha maoshni qo‘lda yozmang: yashirin ma’lumotlarda u boshqacha. Ichki so‘rov (subquery) ishlating.
Namunaviy ma‘lumotlar
| id integer | name text | department_id integer | manager_id integer | salary integer | hire_date text |
|---|---|---|---|---|---|
| 1 | Alisher Yusupov | 1 | NULL | 7000000 | 2018-12-04 |
| 2 | Zarina Yusupov | 2 | NULL | 5000000 | 2019-02-25 |
| 3 | Bobur Mirzayev | 3 | NULL | 9500000 | 2022-12-07 |
| 4 | Doniyor Mirzayev | 1 | 1 | 17000000 | 2021-08-26 |
| 5 | Dilnoza Nazarov | 2 | 2 | 16500000 | 2018-09-14 |
| 6 | Akmal Aliyev | 3 | 3 | 7000000 | 2021-09-01 |
| 7 | Zarina Karimov | 1 | 1 | 5000000 | 2023-10-24 |
| 8 | Farrux Aliyev | 2 | 2 | 12500000 | 2022-01-03 |
| 9 | Ilhom Qodirov | 3 | 3 | 19500000 | 2024-10-19 |
| 10 | Elyor Umarov | 1 | 1 | 17000000 | 2018-02-10 |
| 11 | Nodir Xolmatov | 2 | 2 | 13500000 | 2025-05-14 |
Jadval tuzilishi (CREATE TABLE)
CREATE TABLE employees (id INTEGER PRIMARY KEY, name TEXT, department_id INTEGER, manager_id INTEGER, salary INTEGER, hire_date TEXT);
Natija
Ikki ustun: name, salary.
Namunaviy ma‘lumotlarda kutilgan natija
| Doniyor Mirzayev | 17000000 |
| Dilnoza Nazarov | 16500000 |
| Farrux Aliyev | 12500000 |
| Ilhom Qodirov | 19500000 |
| Elyor Umarov | 17000000 |
| Nodir Xolmatov | 13500000 |
Qatorlar tartibi ahamiyatsiz, ustunlar tartibi muhim. Yechim yashirin, kattaroq ma‘lumotlarda ham tekshiriladi.