Customer (CustomerId, CustomerName) Employee (EmployeeId, EmployeeName, Salary, SupervisorId) Product(ProductId, ProductName, ListPrice) Orders (OrderId, OrderDate, CustomerId, EmployeeId, Total) OrderedProduct (OrderId, ProductId, Quantity, Price) 

Write the code to complete the methods in OrderJDBC.java

Query1: Return the list of products that have not been in any order. Hint: Left join can be used instead of a subquery.	3 marks
Query2: Return the order ids and total amount where the order total does not equal the sum of quantity*price for all ordered products in the order.	3 marks
Query3: Return for each customer their id, name and average total order amount for orders starting on January 1, 2015 (inclusive). Only show customers that have placed at least 2 orders.	3 marks
Query4: Return the employees who have had at least 2 distinct orders where some product on the order had quantity >= 5.	4 marks