highlighting row entries in an email generated by SQL+HTML script
<p>I am using SQL+HTML script to send an email containing columns of a table <code>mytable</code>. The table has only 3 rows.  The third row is the difference of first 2 row and hence I want to highlight it (with some background color). I came across <code>nth-child()</code> selector but somehow it is not working in my case. </p>

<pre><code>SET @tableHTML = 
N'&lt;style type="text/css"&gt;

#box-table
{
font-family: "Arial", "Lucida Grande", Sans-Serif;
text-align: center;
border-collapse: collapse;
}

#box-table th
{
font-size: 13px;
font-weight: bold;
background: #007336;
border: 1px solid #000000;
color: #FFFFFF;
padding-left:5px;padding-right:5px;padding-top:2px;padding-bottom:2px;
}

#box-table td
{
font-size: 12px;
border: 1px solid #000000;
color: #000000;
padding-left:5px;padding-right:5px;padding-top:2px;padding-bottom:2px;
}
&lt;/style&gt;'+  
----------Overview
N'&lt;table id="box-table" &gt;' +
N'&lt;tr&gt;&lt;th&gt;Order Date&lt;/th&gt;
&lt;th&gt;System&lt;/th&gt;
&lt;th&gt;SKU Count&lt;/th&gt;
&lt;th&gt;OUTL $&lt;/th&gt;
&lt;th&gt;OH $&lt;/th&gt;
&lt;/tr&gt;' +

CAST ( ( 
SELECT td = Order_date,'',
td = System,'',
"td/@align" = 'right', td = SKU_Count,'',
"td/@align" = 'right', td = OUTL_$,'',
"td/@align" = 'right', td = OH_$
FROM #mytable
FOR XML PATH('tr'), TYPE 
) AS NVARCHAR(MAX) ) +
N'&lt;/table&gt;&lt;br/&gt;'

EXEC msdb.dbo.sp_send_dbmail 
@recipients='abc@abc.com',
@subject = NULL,
@body = @tableHTML,
@body_format = 'HTML' ;
</code></pre>