SQL Server 2025 introduces a new T-SQL function, called PRODUCT(). The function returns the product of all the numeric (and only) values in the expression. NULL values are ignored and DISTINC values can be set.
Distinct product is an interesting one.