SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table query_parts(table_name varchar(100), col_name varchar(100), agg_func varchar(100));
insert into query_parts
select 'Table1', 'Column X', 'Sum';
1 rows affected

insert into query_parts
select 'Table2', 'Column Y', 'Avg';
1 rows affected

select * from query_parts;


table_name
col_name
agg_func


Table1
Column X
Sum

Table2
Column Y
Avg


select 'select ' + agg_func + '(' + quotename(col_name) + ') from ' + table_name + ';' as query
from query_parts


query


select Sum([Column X]) from Table1;

select Avg([Column Y]) from Table2;