Here is the image of the table of the Question
Here is the First question(in the image)
Above one is question (c)
help me to answer that
this is the other question(below, as Text)
d) Create a database view to display the above output of part (c).
help please,this is urgent