Guest User

Untitled

a guest
Jan 19th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. SELECT exp.Month , exp.ExpenseCount , coll.CollectionCount
  2. FROM
  3. (SELECT
  4. TO_CHAR(ExpenseDate, 'YYYY-MM') as Month,
  5. COUNT(1) as ExpenseCount
  6. FROM Expenses
  7. GROUP BY TO_CHAR(ExpenseDate, 'YYYY-MM')
  8. ) exp ,
  9. (SELECT
  10. TO_CHAR(CollectionDate, 'YYYY-MM') as Month,
  11. COUNT(1) as CollectionCount
  12. FROM Collection
  13. GROUP BY TO_CHAR(CollectionDate, 'YYYY-MM')
  14. ) coll
  15. WHERE exp.Month = coll.Month ;
  16.  
  17. MONTH | EXPENSECOUNT | COLLECTIONCOUNT
  18. 2017-11 1 1
  19. 2017-12 2 3
Add Comment
Please, Sign In to add comment