jump to level 1\ncomplete the sql statement to generate the result table. in the select clause, the column…

jump to level 1\ncomplete the sql statement to generate the result table. in the select clause, the column names must match the columns in the result table exactly. in the where clause, the order and part tables should be combined by comparing columns from each table.\nselect /* type your code here */\nfrom order, part\nwhere /* type your code here */\n

jump to level 1\ncomplete the sql statement to generate the result table. in the select clause, the column names must match the columns in the result table exactly. in the where clause, the order and part tables should be combined by comparing columns from each table.\nselect /* type your code here */\nfrom order, part\nwhere /* type your code here */\n

Answer

Explanation:

Step1: Select required columns

SELECT Quantity, Price, Order.PartNumber

Step2: Set join condition

FROM Order, Part WHERE Order.PartNumber = Part.PartNumber;

Answer:

SELECT Quantity, Price, Order.PartNumber FROM Order, Part WHERE Order.PartNumber = Part.PartNumber;