Each question in this assignment is worth 2 marks. Students are required to attempt all of the questions in this assignment. Students are required to submit a word document that contains the sql query...

Each question in this assignment is worth 2 marks. Students are required to attempt all of the questions in this assignment. Students are required to submit a word document that contains the sql query and the required output for each question. The assignment must be submitted to the assignment drop box on VU Collaborate by the due date. Prod_Description,QtyOnHand, UnitPrice) The OrdersDatabase database maintains information on Customers, Sales representatives, Departments, and Orders. The tblCustomer table maintains information relating to Customers The tblDepartment table stores information relating to full name of each department The tblSales_Rep table stores information on all Sales Representatives and the Department they belong to. The field ManagerNO represents the salesRepNO number. It indicates for each sales representative who is their direct line manager. The tblOrder table stores information relating to Orders, a unique Order number, the date the Order was placed and the Customer who placed the order. The tblOrderLine table maintains information relating to Products that were ordered on each specific Order. Purchase Price represents a Product's Unit Price at the point of sale.