Question: Write the following queries in SQL, issue them, one at a time, to the Company database on the Oracle VM. (1). Retrieve the project number

Write the following queries in SQL, issue them, one at a time, to the Company database on the Oracle VM.

(1). Retrieve the project number and project name of all projects controlled by Administration department.

(2). Show the SSN, first name, and last name of each employee who works for the department that controls ProductY project.

(3). Show the SSN, first name, and last name of each employee who works for Research department or works on Newbenefits project. Write this query using a set operation.

(4). Show the SSN, first name, and last name of all employees who are not managers.

(5). Show the SSN, first name, and last name of each employee who has at least two dependents.

(6). For each employee who works more than 35 hours total on all projects (the employee works on), show the SSN, first name, and last name.

(7). The company decided that all employees who currently work for the Administration department will be moved to the Research department. Write an update statement that implements this change. For this problem, you need to show the screenshot of the update statement only (dont need to show the screenshot of the result).

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!