SELECT 
    customer.first_name, 
    customer.last_name, 
    max(order.order_total) as maximum_order
  FROM 
    customers customer
  INNER JOIN
    orders order
  ON (customer.id = order.customer_id)
  GROUP BY
    customer.id