CSE 3241 30 Quiz 3 | Download for quality grades |
Document Content and Description Below
Use the attached company database schema to write SQL queries for the following questions. 1. (8 Points) Find the names and addresses of employees who work on at least one project located in Housto... n but whose department has no location in Houston. select lname, fname, address from employee where exists (select * from works_on, project where ssn=essn and pno=pnumber and plocation=’Houston’) and not exists (select * from dept_location where dno=dnumber and dlocation=’Houston’) 2. (8 Points) Delete those employees who are directly supervised by ‘Franklin Wong’. delete employee where ssn in (select ssn from employee where superssn in (select ssn from employee where fname=’Franklin’ and lname=’Wong’)) 3. (7 Points) Update the salary by 10% to those employees who do not work on any project. [Show More]
Last updated: 2 years ago
Preview 1 out of 2 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Reviews( 0 )
$2.00
Can't find what you want? Try our AI powered Search
Document information
Connected school, study & course
About the document
Uploaded On
Mar 26, 2023
Number of pages
2
Written in
Additional information
This document has been written for:
Uploaded
Mar 26, 2023
Downloads
0
Views
87
.png)
.png)
