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;