CERTIFIED-DATA-ANALYST-ASSOCIATE · Question #11
A data analyst has created a user-defined function using the following line of code: CREATE FUNCTION price(spend DOUBLE, units DOUBLE) RETURNS DOUBLE RETURN spend / units; Which of the following code
Sign in or unlock CERTIFIED-DATA-ANALYST-ASSOCIATE to reveal the answer and full explanation for question #11. The question stem and answer options stay visible for context.
Question
A data analyst has created a user-defined function using the following line of code:
CREATE FUNCTION price(spend DOUBLE, units DOUBLE) RETURNS DOUBLE RETURN spend / units; Which of the following code blocks can be used to apply this function to the customer_spend and customer_units columns of the table customer_summary to create column customer_price?
Options
- ASELECT PRICE customer_spend, customer_units AS customer_price FROM customer_summary
- BSELECT price FROM customer_summary
- CSELECT function(price(customer_spend, customer_units)) AS customer_price FROM
- DSELECT double(price(customer_spend, customer_units)) AS customer_price FROM
- ESELECT price(customer_spend, customer_units) AS customer_price FROM customer_summary
Unlock CERTIFIED-DATA-ANALYST-ASSOCIATE to see the answer
You've previewed enough free CERTIFIED-DATA-ANALYST-ASSOCIATE questions. Unlock CERTIFIED-DATA-ANALYST-ASSOCIATE for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.