Guruh: 310-21 talaba: turdaliyev samoiddin 2-amaliy topshiriq

GURUH:310-21
TALABA:TURDALIYEV SAMOIDDIN


2-AMALIY TOPSHIRIQ

1. 
   Job_id si 6 ga teng bo’lmagan barcha xodimlarning ma’lumotlarini chiqaruvchi so’rov yarating.
   

CODE: SELECT * FROM employees WHERE NOT (job_id=6)






2.1997-yili ishga qabul qilingan xodimlarning maoshlarini kamayish tartibida chiqaruvchi so’rov yarating.


CODE: SELECT salary FROM employees WHERE hire_date BETWEEN '1997-01-01' AND '1997-12-31' ORDER BY salary desc