Exam Certified Data Analyst Associate topic 1 question 28 discussion

To apply a user-defined function (UDF) in SQL, you generally call the function by its name and pass the appropriate columns as arguments within a SELECT statement. The result is then aliased to give it a descriptive name, which in this case is customer_price. The UDF price created takes two arguments spend and units and returns their division as a DOUBLE. To apply this function to the customer_spend and customer_units columns of the customer_summary table and create a new column customer_price, you'd simply call the price function with these columns as arguments. Answer E statement selects the result of the price function applied to the customer_spend and customer_units columns and labels the result as customer_price for each row in the customer_summary table.