hire_date ustunida ishga olingan sana YYYY-MM-DD ko‘rinishida saqlanadi. Har bir yil uchun o‘sha yili ishga olingan xodimlar sonini chiqaring.
Maslahat: strftime('%Y', hire_date) yoki substr(hire_date, 1, 4) — yilni ajratadi (matn bo‘lib).
Namunaviy ma‘lumotlar
| id integer | name text | department_id integer | manager_id integer | salary integer | hire_date text |
|---|---|---|---|---|---|
| 1 | Nilufar Umarov | 1 | NULL | 17500000 | 2018-10-25 |
| 2 | Madina Nazarov | 2 | NULL | 5000000 | 2020-11-07 |
| 3 | Sardor Yusupov | 3 | NULL | 9000000 | 2025-01-21 |
| 4 | Jasur Umarov | 1 | 1 | 17000000 | 2019-03-11 |
| 5 | Alisher Toshmatov | 2 | 2 | 7500000 | 2023-03-09 |
| 6 | Yusuf Yusupov | 3 | 3 | 9500000 | 2022-11-10 |
| 7 | Jasur Ergashev | 1 | 1 | 7500000 | 2020-07-20 |
| 8 | Bobur Nazarov | 2 | 2 | 18000000 | 2020-06-28 |
| 9 | Otabek Toshmatov | 3 | 3 | 19500000 | 2023-11-24 |
| 10 | Elyor Aliyev | 1 | 1 | 17500000 | 2021-06-10 |
| 11 | Dilnoza Karimov | 2 | 2 | 4500000 | 2019-07-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: year (matn, masalan 2021), hired.
Namunaviy ma‘lumotlarda kutilgan natija
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 2 |
| 2025 | 1 |
Qatorlar tartibi ahamiyatsiz, ustunlar tartibi muhim. Yechim yashirin, kattaroq ma‘lumotlarda ham tekshiriladi.