Part$-5$

For the following questions, use the "Northwind" database in the server. In DBeaver, right click on Northwind, and then New SQL Editor Script. Answer the following questions by writing SQL codes $($and run them to see if they work $$ If they don$$t work, and you can$$t find the error, submit your code $$as$-$is$$ for partial credit$).$ Copy and paste your code in the space below each question. I will grade your code only.

The ER diagram$/$schema for this database is given below. This is a company just like ZAGI, except this one is larger.

# $4)$ We wonder about how much sales each employee made. For this purpose:

# For each employee, show employee ID$,$ employee first, last name, title,

# and sum of $($Unitprice $*$ Quantity $$ Discount$)$

# HINT: Employees, Orders, OrderDetails joined and group by$.$