title: SQL Select Statement with nested group by clause
body: <p>I have 2 tables.   I need to select the column name  and a calculated field from Invoices called balance_due.  </p>
  
  <p>The result of the query should be the name and their balance due from all of their records combined.  </p>
  
  <p>Thanks for any help.</p>