dept (dept_no, dname, loc, mgrcode)
emp (emp_no, ename, designation)
project (proj_no, proj_name, status)
dept. and emp. are related as 1 to many.
Project and emp are related as 1 to many.
i) Give the names of employees who are working on ‘Blood Bank’ project.Inline Code Example Here

dept (dept_no, dname, loc, mgrcode)
emp (emp_no, ename, designation)
project (proj_no, proj_name, status)
dept. and emp. are related as 1 to many.
Project and emp are related as 1 to many.
i) Give the names of employees who are working on ‘Blood Bank’ project.tell me the query.