Mamajonov akmaljon

SELECT first_name, last_name, phone_number
FROM employees
WHERE last_name IN ('Fay', 'Baida', 'Baer');

• 
  jobs jadvalida “Manager” so’zi mavjud qatorlarning minimal maosh (min_salary) hamda maksimal maosh(max_salary) larini chop eting.
  

SELECT_*_FROM_jobs_WHERE_UPPER'>SELECT *
FROM jobs
WHERE UPPER(job_title) LIKE '%MANAGER%';

• 
  jobs jadvalidagi Programmer kasbi uchun keltirilgan o’rtacha qancha maosh berilishi mumkinligini ko’rsatuvchi so’rov yarating. (min_salary*max_salary)/2.
  

SELECT
MIN(min_salary) AS min_salary,
MAX(max_salary) AS max_salary,
(MIN(min_salary) + MAX(max_salary)) / 2 AS combined_salary
FROM jobs
WHERE UPPER(job_title) = 'PROGRAMMER';

• 
  employees jadvalida Xodimlar sonini maoshlari bo’yicha guruhlab kamayish tartibida chiqaruvchi so’rov yarating.
  

SELECT salary, COUNT(*) AS employee_count
FROM employees
GROUP BY salary
ORDER BY salary DESC;