complete the sql statement to generate the result table. in the select clause, the column names must match…

complete 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

complete 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

We need to select Order.PartNumber, Price, and Quantity from the Order and Part tables. So the SELECT clause will be SELECT Order.PartNumber, Price, Quantity.

Step2: Set join condition

We need to combine the Order and Part tables based on the PartNumber column. So the WHERE clause will be WHERE Order.PartNumber = Part.PartNumber.

Answer:

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