Refer to the company schema below to solve the queries EMPLOYEE Fname Minit Lname San AAAA DEPARTMENT Dname Dnumber Mgr_
Posted: Tue Jul 05, 2022 10:27 am
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 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