WillyVervest
/
How_to_code_subqueries
forked from bdelepeleer/How_to_code_subqueries
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.
4 Commits
1 Branch
Branch: master
Branches Tags
${ item.name }
Create branch ${ searchTerm }
from 'master'
${ noResults }
How_to_code_subqueries/exercise-02.sql

exercise-02.sql 183B
Raw Permalink Blame History

1234567 
  1. SELECT invoice_number, invoice_total

  2. FROM invoices

  3. WHERE payment_total >

  4.      (SELECT AVG(payment_total)

  5.       FROM invoices

  6.       WHERE payment_total > 0)

  7. ORDER BY invoice_total DESC