title: Price of each order shown as order price
body: <p>Write a SQL query that shows the price of each order made by customers
  whose last name starts with the letter M. Display the order number, the
  last name on the order, and the price of the order (Order Price). Show the results with the highest order price first. Use single quotes to provide the aggregate alias. </p>
  
  <p>Produces a result making sure it answers the question fully</p>
  
  <pre><code>Select `CustomerLastName`,petshop_order.OrderNo, 
  sum(item.ItemPrice) as `Order Price`
  from customer,petshop_order,petshop_order_item,item
  where `CustomerLastName` like "M%"
   And (customer.ssn=petshop_order.ssn
   And petshop_order.OrderNo = petshop_order_item.OrderNo
   And petshop_order_item.SKU=item.SKU)
  Group by `OrderNo`
  Order By `Order Price` DESC;
  </code></pre>
  
  <p>I understand that this may be poor syntax....This is very my first Database Class. Unfortunately, this how the Professor taught it to us.</p>