Create an amortization table with SQL

I have a list of credits, let's assume they are only two for ease:

Credit #1 and credit #2: One has 3 months of payments missing and the other has 6 months left of payments.

It would like to obtain a table which can produce a dataset with the due date of the following payments:

Original dataset:

Desired dataset:

Topic programming sql

Category Data Science

About

Geeks Mental is a community that publishes articles and tutorials about Web, Android, Data Science, new techniques and Linux security.