I have a transactional application on MSSQL database where people can send money to other people at anytime (More like Cashapp), i want to be able to predict a customer's frequent beneficiary on random days.

AIM: I want to be able to tell a customer on 27th of the month "Hey Mr. A, you mostly send money to Mr. B on the 27th of every month, do you want to do so today?"

How best can i achieve this using SQL?

  • 1
    Having your table(s) definition would be handy to know.
    – J.D.
    Commented Oct 24, 2023 at 12:35


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.