Advertisement
Guest User

Untitled

a guest
Oct 1st, 2014
231
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.52 KB | None | 0 0
  1. Query 1:
  2. SELECT
  3. username,
  4. COUNT(result_of_action) number_of_ptps,
  5. SUM(ptp_amount) total_of_ptps
  6. FROM debtor_contact_history dch
  7. WHERE ptp_date BETWEEN '2014-09-24' AND '2014-09-24' AND result_of_action = 'PTP'
  8. GROUP BY username
  9.  
  10. Query 2:
  11. SELECT ptp_user,
  12. SUM(transaction_amount) total_payments,
  13. COUNT(transaction_amount) number_of_payments
  14. FROM financial_transactions
  15. WHERE sale_date BETWEEN '2014-09-24' AND '2014-09-24'
  16. AND transaction_type = 'PAY'
  17. AND (ptp_user IS NOT NULL AND ptp_user <> '')
  18. GROUP BY ptp_user
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement