Write a query in SQL to list the employees of the grade same as the grade of TUCKER or experience is more than SANDRINE and who are belonging to SYDNEY or PERTH
- برمجة سي كيو ال sql
- 2021-09-07
- mhanasmh00489829403
الأجوبة
SELECT *
FROM employees e,
department d,
salary_grade s
WHERE e.dep_id= d.dep_id
AND d.dep_location IN ('SYDNEY',
'PERTH')
AND e.salary BETWEEN s.min_sal AND s.max_sal
AND (s.grade IN
(SELECT s.grade
FROM employees e,
salary_grade s
WHERE e.salary BETWEEN s.min_sal AND s.max_sal
AND e.emp_name = 'TUCKER')
OR age (CURRENT_DATE,hire_date) >
(SELECT age(CURRENT_DATE,hire_date)
FROM employees
WHERE emp_name = 'SANDRINE')) ;Sample Output:
emp_id | emp_name | job_name | manager_id | hire_date | salary | commission | dep_id | dep_id | dep_name | dep_location | grade | min_sal | max_sal --------+----------+----------+------------+------------+---------+------------+--------+--------+-----------+--------------+-------+---------+--------- 64989 | ADELYN | SALESMAN | 66928 | 1991-02-20 | 1700.00 | 400.00 | 3001 | 3001 | MARKETING | PERTH | 3 | 1501 | 2100 68454 | TUCKER | SALESMAN | 66928 | 1991-09-08 | 1600.00 | 0.00 | 3001 | 3001 | MARKETING | PERTH | 3 | 1501 | 2100 (2 rows)
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال