company schema below to solve the queries EMPLOYEE Fname Minit Lname San AAAA DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation WORKS ON Essn Bdate Address Sex Salary Pno Hours Dnum DEPENDENT Essn Dependent_name Sex Bdate Relationship Super_ssn Dno
Question 6) (4 points) Write the following query in SQL Query: Retrieve the names of projects that have all male employees from the research department
Refer to the Refer to the company schema below to solve the queries EMPLOYEE Fname Minit Lname San AAAA DEPARTMENT Dname Dnumber Mgr_
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am