Reddit

A data analyst has created a user-defined function using the following code:

CREATE FUNCTION price(spend DOUBLE, units DOUBLE)
RETURNS DOUBLE
RETURN spend / units;

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 customer_summary table to create a customer_price column?

Exam-Like

SELECT PRICE customer_spend, customer_units AS customer_price FROM customer_summary

2.9%

SELECT price - FROM customer_summary_

2.9%

SELECT function(price(customer_spend, customer_units)) AS customer_price FROM customer_summary

2.9%

SELECT double(price(customer_spend, customer_units)) AS customer_price FROM customer_summary

0.0%

SELECT price(customer_spend, customer_units) AS customer_price FROM customer_summary

91.4%

Databricks Certified Data Analyst - Associate

Get started today

Comments