|
Ma’lumotlar bazasi fanidan 7-8-9 mavzular yuzasidan amaliyot topshiriqlari
|
| Sana | 09.12.2023 | | Hajmi | 2,24 Mb. | | #114296 |
Bog'liq Rafiqaliyev Navro\'zbek bazadan bajargan ishi(1)
O`ZBEKISTON RESPUBLIKASI RAQAMLI TEXNOLOGIYALAR VAZIRLIGI
Muhammad Al-Xorazmiy nomidagi Toshkent axborot texnologiyalari universiteti Nurafshon filiali
Ma’lumotlar bazasi fanidan
7-8-9 mavzular yuzasidan amaliyot topshiriqlari
Bajardi: 210-22 guruh
Talabasi:Rafiqaliyev Navro’zbek
Tekshirdi: Turg'unaliyev Shohruzbek
Toshkent -2023
1.SELECT first_name, salary * 12 AS yearly_salary
FROM employees
WHERE first_name = 'John';
2.SELECT employee_id, first_name, salary * 0.5 AS increased_salary
FROM employees
WHERE employee_id IN (200, 201, 202);
3.SELECT job_id,last_name AS ismi
FROM employees
WHERE job_id=6;
4.SELECT *
FROM employees
WHERE hire_date > '1998-01-01';
5.SELECT first_name, last_name, salary
FROM employees
WHERE hire_date BETWEEN '1987-01-01' AND '1995-01-01';
6.SELECT first_name, last_name, phone_number
FROM employees
WHERE salary IN (6000, 8000, 10000);
7.SELECT *
FROM employees
WHERE salary BETWEEN 4000 AND 10000;
8.SELECT *
FROM employees
WHERE first_name LIKE 'S%';
9.SELECT first_name , ' ' , last_name AS full_name, email, phone_number
FROM employees
WHERE last_name LIKE '%o%';
10.SELECT first_name, phone_number, job_id
FROM employees
WHERE salary > 10000
ORDER BY job_id;
11.SELECT first_name, last_name, (salary * 0.12) AS tax_amount
FROM employees
WHERE phone_number LIKE '%8%';
12.SELECT job_id, COUNT(*) AS employee_count
FROM employees
GROUP BY job_id;
13.SELECT department_id, COUNT(*) AS employee_count
FROM employees
GROUP BY department_id
HAVING COUNT(*) > 1;
14.SELECT first_name, last_name, salary
FROM employees
WHERE salary * 12 > 100000;
15.SELECT *
FROM employees
WHERE first_name LIKE '%LL%' OR last_name LIKE '%LL%';
16.SELECT *
FROM employees
WHERE EXTRACT(YEAR FROM hire_date) = 1997
ORDER BY salary;
17.SELECT first_name, last_name, phone_number
FROM employees
WHERE last_name IN ('Fay', 'Baida', 'Baer');
18.
19.SELECT job_title, (min_salary + max_salary) / 2 AS ortacha_maosh
FROM jobsWHERE job_title = 'Programmer';
20.SELECT salary, COUNT(*) AS employee_count
FROM employees
GROUP BY salary
ORDER BY salary DESC;
|
| |
