0
Pls tell me its second and third part.
Consider the following database tables and answer queries using SQL. Employee (Emp#, Name) Assigned_to (Project#, Emp#) Project (Project#, Project_Name, Chief_architect) 1. Print the Details of the employee working on project “AAA” 2-Print the employee number of employee who work on all projects. 3-Print the emp# of employee other than employee 39 who work on at least one project that employee 39 works .
1 Réponse
+ 1
2.
Select count(*) from employee_table
Where Project='Project_Name' and Project='Chief_architect';
3.
Select emp# from emp_table
Where not emp_no = 39 and
Project = (select project from emp_table where emp_no =39);
Hope it works!!