Question: Please write SQL statement for each of question 1. Produce table Table1 (ID) which contains all the Eng techs who create products that include all

Please write SQL statement for each of question
1. Produce table Table1 (ID) which contains all the Eng techs who create products that include all the products created by Eng tech with id = 0000000018.
2, Produce table Table2 (Parent ID, Number Of Children) which contains that the em- ployees who have at least 2 children with height less than 170 cm and the number of these children. Your query should work if 2 were replaced with 200.
PHONE EMPLOYEE CHILD PK PK,FK1 ID PK,FK1 NAME PK ID PK,FK1 LD PK SSN FNAME LNAME DOB NAME HEIGHT CREATES ENG TECH PK,FK1PRODUCTID PK,FK1ID MANAGER PK,FK1 ID FK2 HATERID DESIGNS PK,FK2 ID PK,FK1 PIN PRODUCT PK I PRODUCT!D NAME ENGINEER TECHNICIAN PK,FK1ID PK,FK1ID COMPLETIONDATE PROTOTYPE PK PIN FK1 PRODUCTID COMPLETIONDATE
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
