Avg in Sql

Hi,

Please refer below code

SQL

DECLARE @Temp AS TABLE(col1 int,col2 int)
INSERT INTO @Temp VALUES(20,21)
INSERT INTO @Temp VALUES(50,50)
SELECT col1,col2,  CAST((CAST(col1 AS DECIMAL) + CAST( col2 AS DECIMAL))/ 2 AS DECIMAL(16,2)) [Avg] FROM @Temp

Screenshot