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: 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
Get step-by-step solutions from verified subject matter experts
