Order

$$ OrderCode PartNumber Quantity

A$366621$

R$618271$

Z$234923$

R$584924$

Part

$$ PartNumber PartName Price

$827$ Left wizard $1000$

$662$ Wingding $11$

$492$ Buzzer $0\mathrm{.}4$

An arrow points from the Order table's PartNumber column to the Part table's primary key column.Complete the SQL statement to generate the Result table. The column names in the SELECT clause must match the Result table exactly.

$/*$ Type your code here $*/$

$/*$ Type your code here $*/$

Result

OrderCode PartName

A$36$ Wingding

R$61$ Left wizard

Z$23$ Buzzer

R$58$ Buzzer