Greenplum Query results to Email HTML table

[krux_rap]

Hello,

I'm trying to send email results from Greenplum query as HTML table with status Red/Green

Select Server, Last_Date from Table;

Query Results

Server, Last_Date
Prod, 2018-04-09

Final email Output in HTML Table

Server Status LastDate
Prod GREEN(BOX) 2018-04-09 (if the date is within 24 hours) - Green color status
UAT RED (BOX) 2018-04-08 (if the date not within 24 hours) -- Red color Status

Thanks

[Larz60+]

I'm trying to send email results from Greenplum query as HTML table with status Red/Green

Ok, what have you tried?
where are you having problems
Show the code you have written so far and where you think the problem lies.