Новый курс! Каждый программист должен знать генеративный ИИ!
Попробуйте бесплатный урок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 ответ
+ 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!!