Q.3) (25 points) Use the ex database for this question. Write a query that repli

Question

Q.3) (25 points) Use the ex database for this question. Write a query that replicates the result set below, matching all data and format aspects, including column headers.

] Tables | | active invoices color-sample customers date-sample departments Columns Ep Indexes department-number department-name Foreign Keys > ] Triggers employees Columns employee_id last_name first_name department-number manager-id ] Indexes Foreign Keys ] Triggers float-sample null-sample paid-invoices > projects Columns project-number employee-id Indexes

Explanation / Answer

select p.project_number, e.first_name|| ' ' || e.last_name as employye_name, d.department_name

from employees e, departments d, projects p

where e.employee_id = p.employee_id

and e.department_number = d.department_number;

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.