Question Text

Question $3$

Create a PL$/$SQL an anonymous block that will retrieve the author's surname and name, book

name, the number books ordered, and the accumulated royalties. Accumulated author

royalties is $10\%$ profit made per book. Display the author royalties per order for order $1002.$

Your output should resemble the output below.

Author Royalties per order

Order Number: $1002$

Author: Tina Peterson

$2$ copies of book named: Database Implementation were ordered.

Royalties accumulated: R$04\mathrm{.}91$

PL$/$SQL procedure successfully completed.