Question: Write down the SQL (Structured Query Language) to answer the following query: Find out all the Employees' names (first names and last names) who works

Write down the SQL (Structured Query Language) to answer the following query:Write down the SQL (Structured Query Language) to answer the following query: Find out all the Employees' names (first names and last names) who works in the Research department or works in the "Development" Project.

Consider the following database schema of the "Company" database. EMPLOYEE Frame Minit Lname Ssn Bdate Address Sex Salary Super_ssn Dno DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT_LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation Dnum WORKS ON Essn Pne Hours DEPENDENT Essn Dependent name Sex Bdate Relationship

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!