Pls tell me its second and third part. | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
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 .

8th Jan 2020, 3:56 AM
Piyush Srivastava
Piyush Srivastava - avatar
1 Answer
+ 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!!
19th Jan 2020, 3:26 AM
Akash
Akash - avatar