Import the midterm script and use the following logical schema to answer the questions below. Include the typed query and the screenshot of the result.

(50 points: 5 points each query)

Note that you will not get credit if you use techniques that haven't been taught in the class (e.g., aggregate function, View, GROUP BY or ORDER BY).