Guest User

Untitled

a guest
Jun 22nd, 2018
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.18 KB | None | 0 0
  1. SELECT DATE_FORMAT( created_at, "%b %Y" ) AS period, SUM( ABS( amount ) ) AS volume
  2. FROM operations
  3. WHERE amount <20000
  4. GROUP BY EXTRACT(
  5. YEAR_MONTH FROM created_at )
  6. LIMIT 0 , 30
Add Comment
Please, Sign In to add comment