sql server - How to SUM the values in a column in SQL -

i have following query in sql:

select top 1000 [date]       ,[apderm]       ,[in house]       ,[rad emr orders]       ,[emr orders]   [database].[dbo].[mytable] 

which produces this:

how can write query add each column , insert new row under [mytable]

something this:

use union operator:

select [date]       ,[apderm]       ,[in house]       ,[rad emr orders]       ,[emr orders] [database].[dbo].[mytable] union select  [date]       , sum([apderm])       , sum([in house])       , sum([rad emr orders])       , sum([emr orders](   [database].[dbo].[mytable]