Mamajonov akmaljon


SELECT first_name, last_name, phone_number FROM



Yüklə 84,75 Kb.
səhifə4/4
tarix25.12.2023
ölçüsü84,75 Kb.
#193769
1   2   3   4
Akmaljon MB

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;
Yüklə 84,75 Kb.

Dostları ilə paylaş:
1   2   3   4




Verilənlər bazası müəlliflik hüququ ilə müdafiə olunur ©azkurs.org 2024
rəhbərliyinə müraciət

gir | qeydiyyatdan keç
    Ana səhifə


yükləyin