SELECT
userID,
paymentDateTime,
paymentAmount,
paymentPeriod,
DATE_ADD(DATETIME(paymentDateTime), INTERVAL paymentPeriod MONTH) expirationDateTime

FROM
`uptimerobot-001.ur.payments`

WHERE
  paymentPeriod = 12
  AND paymentStatus = 1
  AND DATE_ADD(DATE(paymentDateTime), INTERVAL paymentPeriod MONTH) BETWEEN '2022-11-01' AND '2022-12-31'

ORDER BY
  expirationDateTime DESC