How to Include an url in the BI Publisher Bursting Email Body

Summary

How to Include an url in the BI Publisher Bursting Email Body

Content

I have a link which needs be sent to the recipients going through the busting email. Here is my sample bursting email sql. Could you please help how do i  include the url in the email body?

Click here to take the Exit Survey is the link which is right now displaying as a link since it is part of the email body.

 

Could you please help me with this?

 

SELECT
KEY,
TEMPLATE,
LOCALE,
OUTPUT_FORMAT,
DEL_CHANNEL,
PARAMETER1,
PARAMETER2,
PARAMETER3,PARAMETER4,PARAMETER5,PARAMETER6,PARAMETER7
from