PLEASE NOTE: Determine the price of the ordered products at the day of the order. The price of a product of day d is the price in the entry with the largest from-value f such that f Database Consider a database for an online store with the following tables. (You can find the ER-Model on Canvas.) Price (prodID, from, price) - Product (prodID, name, quantity) PO (prodID, orderID, amount) - Order (orderID, date, address, stalus, trackingNum- ber, custID, shipID) Shipping (shipID, company, time, price) - Customer (custID, name) Address (addrID, custID, address) Problem Implement the following query in SQL. - Determine the order-ID and the total price of each order. (Note that the total price of an order is the price for the ordered products on the day of the order plus the price of the selected shipping.) Note. The requested query is quite complicated and long). The main problem is that you have to determine the price of the ordered products the day of the order. Recall that the Price table stores the price of a product starting at a particular date (from atribute). Hence, the price of a product on day d is the price in the entry with the largest from-value / such that