Scalar functions in T-SQL return you a single value while table-valued functions return a table.

Table-valued functions (TVF) are kind of like views only you hand in some variables. In aggregate functions you write your own versions of some of the "aggregates" associated with GROUP BY clauses such as SUM and COUNT and STRING_AGG. Meh.