this ashyrimert has a hutal ed loo poids. formulate Queries Imagine that Howard has asked vou to write some queries to help him make better use of his data, for each information request below, write a single query that provides the answer set. When a task specfies which columens to show in the fesult, show only the columns listed and show them in the order specfied. Save your gueries and name them aporopriately Moter The "School" table is sinvilar to the table you imported in a prior assignment excopt that the data are from Colorado rather than Aruona. Note: There are two "Price" fields in this database. The Product table has a field named "currentPrice" This records the price at which each product is currently offered for sale. The OrderDetail table has a field namied "price" This field records the price actually paid for a product on a partoular sale, which may difler for several reasons. A particular product may be discounted and therefore sell for a diflesent pcice than currently listed. More importantly, the current grice wit lkoly change over time. Ass it does, we need to know what price wars actualy paid for the product when it was purchased. this ashyrimert has a hutal ed loo poids. formulate Queries Imagine that Howard has asked vou to write some queries to help him make better use of his data, for each information request below, write a single query that provides the answer set. When a task specfies which columens to show in the fesult, show only the columns listed and show them in the order specfied. Save your gueries and name them aporopriately Moter The "School" table is sinvilar to the table you imported in a prior assignment excopt that the data are from Colorado rather than Aruona. Note: There are two "Price" fields in this database. The Product table has a field named "currentPrice" This records the price at which each product is currently offered for sale. The OrderDetail table has a field namied "price" This field records the price actually paid for a product on a partoular sale, which may difler for several reasons. A particular product may be discounted and therefore sell for a diflesent pcice than currently listed. More importantly, the current grice wit lkoly change over time. Ass it does, we need to know what price wars actualy paid for the product when it was purchased