title: Returning Top 10 MYSQL query results with additional fields from different tables
body: <p>I need to return the Top 10 customers based on their revenue gain, while also displaying the number of their orders and the total weight of their orders.    </p>
  
  <p>First, we have the customer table, which stores the customer accounts.
  Second, we have the invoice table, which stores the revenue per order. This will be used to get the Top 10 customer, as they're ranked by the revenue.
  And finally, I have the order table, which stores the other details about the order, such as the weight.</p>
  
  <p>I tried:</p>
  
  <pre><code>SELECT (c.account_number as Account, c.customer_name as Name, SUM(i.total_charge) as Revenue, COUNT(s.order) as NumberOfOrder, SUM(s.tot_weight) as Weight)
  FROM t_customer as c
  JOIN t_invoice as i ON c.account_number = i.account_number
  JOIN t_shipment as s ON c.account_number = s.shipper_account 
  WHERE s.ship_date BETWEEN '2016-08-01' AND '2016-08-31'
  GROUP BY c.account_number
  ORDER BY SUM(i.total_charge) DESC LIMIT 10
  </code></pre>
  
  <p>I thought I had it correct but it only returned SQL Error (1241): Operand should be 1 column(s). Thank you for your help.</p>