From the following tables, write a SQL query to find those employees whose first name contains a letter ‘z’. Return first name, last name, department, city, and state province
- برمجة سي كيو ال sql
- 2021-09-01
- mhanasmh00489829403
الأجوبة
SELECT E.first_name,E.last_name,
D.department_name, L.city, L.state_province
FROM employees E
JOIN departments D
ON E.department_id = D.department_id
JOIN locations L
ON D.location_id = L.location_id
WHERE E.first_name LIKE '%z%';Sample Output:
first_name last_name department_name city state_province Mozhe Atkinson Shipping South San Francisco California Hazel Philtanker Shipping South San Francisco California Elizabeth Bates Sales OX9 9ZB Oxford
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال