Design and transform analytics data in Microsoft Fabric

CREATE FUNCTION sales.fnOrderLinesByCustomer (@CustomerKey int)
RETURNS TABLE
AS
RETURN
(
    SELECT OrderLineKey, OrderDate, NetAmount
    FROM sales.OrderLine
    WHERE CustomerKey = @CustomerKey
);

CREATE FUNCTION sales.fnOrderLinesByCustomer (@CustomerKey int)
RETURNS decimal(18,2)
AS
BEGIN
    RETURN (
        SELECT SUM(NetAmount)
        FROM sales.OrderLine
        WHERE CustomerKey = @CustomerKey
    );
END;

CREATE FUNCTION sales.fnOrderLinesByCustomer (@CustomerKey int)
RETURNS @Rows TABLE (OrderLineKey int, OrderDate date, NetAmount decimal(18,2))
AS
BEGIN
    INSERT INTO @Rows
    SELECT OrderLineKey, OrderDate, NetAmount
    FROM sales.OrderLine
    WHERE CustomerKey = @CustomerKey;
    RETURN;
END;

CREATE PROCEDURE sales.fnOrderLinesByCustomer @CustomerKey int
AS
BEGIN
    SELECT OrderLineKey, OrderDate, NetAmount
    FROM sales.OrderLine
    WHERE CustomerKey = @CustomerKey;
END;