Advertisement
Guest User

Untitled

a guest
Feb 10th, 2016
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. SELECT
  2. PoolMonth,
  3. SUM(OriginationAmt) AS Origination,
  4. SUM(IF(PmtDue = 201512, AmtPaid, 0)) AS `201512`,
  5. SUM(IF(PmtDue = 201601, AmtPaid, 0)) AS `201601`,
  6. SUM(IF(PmtDue = 201602, AmtPaid, 0)) AS `201602`
  7. FROM
  8. Loans
  9. GROUP BY
  10. PoolMonth;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement