SQL Server scalar user defined functions must be called with 2 part names. You need to write as username before function.
So if your function name is "function1" and is defined in the dbo schema, then instead of
"select function1()" you should call it as "select dbo.function1()"
Functions will run like below:
select dbo.AVG(columns name) from (table_name) - Returns the average value
select dbo.COUNT(columns name) from (table_name) - Returns the number of rows
select dbo.FIRST(columns name) from (table_name) - Returns the first value
select dbo.LAST(columns name) from (table_name) - Returns the last value
select dbo.MAX(columns name) from (table_name) - Returns the largest value
select dbo.MIN(columns name) from (table_name) - Returns the smallest value
select dbo.SUM(columns name) from (table_name) - Returns the sum
