Please follow the below steps to achieve this:
1) Between the main select script with the 3 select statements and the E-mail activity, add an Execute Script activity
2) In that script, input a select count statements for the 3 queries that are being ran previously in the script into one single line. Example:
select count (*) HL from table_1; select count (*) HL from table_2; select count (*) HL from table_3;
4) In the E-mail activity, please tick the option " Append clipboard contents"
This will append the row count for each select statement at the end of the e-mail.
