SELECT COLUMN_1, COLUMN_2,
case when STATUS=1 then
'<span style="font-size:12px;letter-spacing: .3px;display: inline-block;padding: .4rem .66666667rem;font-size: 89%;
font-weight: 500;
line-height: 1;
text-align: center;
white-space: nowrap;
vertical-align: baseline;padding-right:.6em;padding-left:.6em; border-radius: 10rem;background-image: linear-gradient(310deg,#0b1a6d,#7586e4);color: #ffffff;border-color: #ffeb3b;font-weight:bold;border: 2px solid #fffde7;
box-shadow: 0 5px 10px -3px rgb(0 0 0 / 23%), 0 6px 10px -5px rgb(0 0 0 / 25%)">Approved</span>'
when STATUS=2 then
'<span style="font-size:12px;letter-spacing: .3px;display: inline-block;padding: .4rem .66666667rem;font-size: 89%;
font-weight: 500;
line-height: 1;
text-align: center;
white-space: nowrap;
vertical-align: baseline;padding-right:.6em;padding-left:.6em; border-radius: 10rem;background-image: linear-gradient(310deg,#17ad37,#98ec2d);color: #024d05;border-color: #ffeb3b;font-weight:bold;border: 2px solid #fffde7;
box-shadow: 0 5px 10px -3px rgb(0 0 0 / 23%), 0 6px 10px -5px rgb(0 0 0 / 25%)">Cancel</span>'
when STATUS IS NULL then
'<span class="subscribe" aria-hidden="true" style="background-image: linear-gradient(310deg,#600700,#ff392b);color: #ffffff;border-color: #fee8dc;letter-spacing: .3px;padding-right: .6em;padding-left: .6em;border-radius: 10rem; display: inline-block;padding: .4rem .66666667rem;
font-size: 85%;
font-weight: 500;
line-height: 1;
text-align: center;
white-space: nowrap;
vertical-align: baseline;font-size:12px;font-weight:bold;border: 2px solid #fffde7;
box-shadow: 0 5px 10px -3px rgb(0 0 0 / 23%), 0 6px 10px -5px rgb(0 0 0 / 25%)">Processing</span>'
END as STATUS
FROM TABLE_NAME