Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 COMPLETIONDATEStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started