1. For each order, list the order date along with the balance for the order.

2. For each order placed after October 15, 2015, list the order date along with the balance for the order.3.Use the lN operator to find the credit limit of each customer that placed an order on October 15, 2015.4.Calculate the value of stored items by multiplying storehouse times(*) price. Use the column name CURRENT VALUE for the calculated field.List the item number, storehouse, price, and CURRENT VALUE, where the price was over 100.5.For each order, list the order number, quoted price, and the item description whenthe category is TOY6.Use the inner join syntax to show the customer name and the matching order dates.7.Show all item num from the item table, and a matching quoted price from the order line table (show blank if there is no matching quoted price).