database by using MYSQL bo teaching employee fname varchar(15) minit varchar(1)

Question

database by using MYSQL

bo teaching employee fname varchar(15) minit varchar(1) name varchar (15) ssn har(9) bdate date address varchar (50) sex char(1) H salary decimal (10,2) Super ssn char(9) dno int(4) bo teaching dept locations dnumber nt 4) dlocation varchar (15) bo teaching dependent essn char (9) dependent name Varchar (15) sex char(1) bdate date relationship varchar(8) O bo teaching department dname varchar(25) dnumber int(4) ssn char(9) mgrstartdate date bo teaching works on essn char(9) pno nt(4) H hours decimal (4,1) O bo teaching project R pname varchar (25) pnumber nt(4) plocation varchar(15) dnum nt (4)

Explanation / Answer

Retrieve the names of each employee who works in all projects controlled by department 5

below is the sql query

select fname,lname from employee where dno in (select d.dnumber from department d inner join project p on d.dnumber = p.dnum where d.dnumber = 5)

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.