get previous 12 month data and if not exist then add zero in mysql
Build a table of all months.
LEFT JOIN to that table.  Viola, the zeros show up.


Well, you might get NULLs instead of zeros.  So use the IFNULL(application, 0) function.

BTW, MariaDB has a nifty way to generate sequences of numbers; see "seq".