How to make a sql program

Answer 1

SQL is used to work with database. So it is not enough to build a program. You have to use programming languages such as Java, php, python, etc.

Answer 2

I think he is asking about PL/SQL.
You can apply some basic programming methodologies using PL/SQL.