As we all know that database mail always send in plain text, In this blog we will send mail in HTML format.
First of all you need to configure database mail, Please refer this article:
Now in query you need to provide @body_format tag to HTML like this and profile created profile name.