SQL Func avg price

Func avg price

CREATE FUNCTION AveragePrice(@booktype varchar(12))
RETURNS money
AS
BEGIN
	DECLARE @avg money
	SELECT @avg = avg(price)
	FROM titles
	WHERE type = @booktype
	
	RETURN @avg
END
GO
CREATE FUNCTION AveragePrice2(@booktype varchar(12))
RETURNS money
AS
BEGIN
	
	RETURN ( SELECT avg(price)
	         FROM titles
	         WHERE type = @booktype)
END
GO
SELECT title_id, price
FROM titles
WHERE price > dbo.AveragePrice('business')
AND type = 'business'
GO
SELECT title_id, price
FROM titles
WHERE price > dbo.AveragePrice2('business')
AND type = 'business'
GO
DECLARE @avg money
EXEC @avg = dbo.AveragePrice 'business'
SELECT @avg
GO