Question
Write/Run SQL queries for the following use cases. 1)List all name of employees, the projects that they have been working on, and the amount of
Write/Run SQL queries for the following use cases.
1)List all name of employees, the projects that they have been working on, and the amount of time they spent for those projects.
2) Retrieve all employees whose address is in Atlanta, GA.
3)List all the department names which are located in Houston.
4)Retrieve all distinct salary values of very employee.
5) A new person whose name is Joshua T Miller has been hired. Add this new employed person to the system along with his following information:
SSN: 456363313
birth date: 1971-10-18
address: 98 Oak Forest, Katy, TX
salary: 37000
superssn: 456363313
dno: 4
6)Joshuas salary has been increased with 10%. Make the required update.
7)Joshua left the company after working 3 years. Delete his personal record from the system.
8)Make a list of all project numbers and project names for projects that involve an employee whose last name is 'Smith', either as a worker or as a manager of the department that controls the project.
EMPLOYEE Address Sex Salary |Super_ssn Dno Fname ii Lname John FranklinT Wong 333445555 1955-12-08 638 Voss, Houston, TXM 40000 888665555 5 Alicia JenniferSWallace 9876543211941-06-20 291 Berry, Bellaire, TX Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445555 5 Joyce AhmadVJabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 987654321 4 Jam Bdate B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5 J Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 4 F 43000 888665555 4 A English453453453 1972-07-31 5631 Rice, Houston, TXF 25000 3334455555 es EBorg 888665555 1937-11-10450 Stone, Houston, TXM 55000 NULL DEPARTMENT DEPT LOCATIONS Dnumber Dname Research Administration Headquarters Dnumber 5 4 Mgr_ssn 333445555 987654321 888665555 Mgr_start_date 1988-05-22 1995-01-01 1981-06-19 Dlocation Houston Stafford 4 Bellaire Sugarland Houston
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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