You are tasked with creating a function in your lakehouse that calculates the average sales per day. Describe the steps you would take to create this function, including the use of parameters and the benefits of using a function over a direct SQL query.