SQL vazifa to'plami 7.5 Darajasi
Quyidagi jadvallar berilgan:
| id | name | salary | years_experience | department_id |
|---|---|---|---|---|
| 1 | John | 1300 | 1 | 1 |
| 2 | Sam | 300 | 0 | 3 |
| 3 | Jorge | 4300 | 5 | 2 |
| 4 | Peter | 3000 | 2 | 4 |
| 5 | Andrew | 1500 | 3 | 2 |
| 6 | Mark | 800 | 0 | 1 |
| 7 | Donald | 2400 | 2 | 4 |
| 8 | Evans | 1900 | 2 | 4 |
| 9 | Max | 5500 | 8 | 2 |
| 10 | Erick | 1200 | 1 | 3 |
| id | department_id | income_per_year |
|---|---|---|
| 1 | 3 | 95000 |
| 2 | 2 | 110000 |
| 3 | 4 | 95000 |
| 4 | 1 | 100000 |
| id | name |
|---|---|
| 1 | Ruby |
| 2 | PHP |
| 3 | Vue.js |
| 4 | React |
Ularni quyidagi vazifalarni yeching:
Bo'lim nomi va unga tegishli yorliqni tanlang.
Agar bo'limning yillik daromadi 90000 dan katta bo'lsa, unda yorliq 'Normal department' bo'ladi.
Agar bo'limning yillik daromadi 95000 dan katta bo'lsa, shu bilan birga, bu bo'limdagi xodimlarning yillik maoshi 50000 dan oshmasa, unda yorliq 'Good department' bo'ladi.
Agar bo'limning yillik daromadi 100000 dan katta bo'lsa, shu bilan birga, bu bo'limdagi xodimlarning yillik maoshi 50000 dan oshmasa va xodimlarning ish tajribasi yili 10 yildan kam bo'lmasa,
unda yorliq 'The best department' bo'ladi.
Aks holda 'Average department'.
