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: 1 year ago

Preview 1 out of 2 pages