SELECT
 COUNT(1) AS new_orders_count,
 ROUND(SUM(paymentAmount / paymentPeriod)) AS new_mrr


FROM payments p
LEFT JOIN
    users u
ON
u.userID = p.userID

WHERE
    paymentStatus = 1 AND paymentPeriod > 0 AND paymentNewUpgradeRenewal = 1 AND
 paymentDateTime > '2022-07-01 00:00:01' AND paymentDateTime < '2022-08-09 23:59:59'
 AND u.userRegisterDateTime > '2022-07-01 00:00:01' AND u.userRegisterDateTime < '2022-08-09 23:59:59'