WillyVervest
/
How_to_code_summary_queries
forked from bdelepeleer/How_to_code_summary_queries
Watch 1
Star 0
Fork 0
Code Issues 0 Pull Requests 0 Releases 0 Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
8 Commits
1 Branch
Branch: master
Branches Tags
${ item.name }
Create branch ${ searchTerm }
from 'master'
${ noResults }
How_to_code_summary_queries/exercise-06.sql

exercise-06.sql 122B
Raw Permalink Blame History

123 
  1. SELECT account_number, SUM(line_item_amount) AS line_item_sum

  2. FROM invoice_line_items

  3. GROUP BY account_number WITH ROLLUP