Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Query 1:
- SELECT
- username,
- COUNT(result_of_action) number_of_ptps,
- SUM(ptp_amount) total_of_ptps
- FROM debtor_contact_history dch
- WHERE ptp_date BETWEEN '2014-09-24' AND '2014-09-24' AND result_of_action = 'PTP'
- GROUP BY username
- Query 2:
- SELECT ptp_user,
- SUM(transaction_amount) total_payments,
- COUNT(transaction_amount) number_of_payments
- FROM financial_transactions
- WHERE sale_date BETWEEN '2014-09-24' AND '2014-09-24'
- AND transaction_type = 'PAY'
- AND (ptp_user IS NOT NULL AND ptp_user <> '')
- GROUP BY ptp_user
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement