Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- YEAR(paymentDateTime) AS year,
- MONTH(paymentDateTime) AS month,
- COUNT(DISTINCT userID) customersWithPayment,
- ROUND(SUM(paymentAmount),2) revenue
- FROM
- payments
- WHERE
- paymentStatus = 1
- AND paymentType = 2
- GROUP BY
- year, month
- ORDER BY
- year DESC,
- month DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement