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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started