Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
To efficiently apply custom logic on a string column named 'city' in the 'location' table, a data engineer decides to create a SQL user-defined function (UDF). Which of the following code snippets correctly defines this SQL UDF?
A
CREATE UDF combine_california (city STRING)RETURN CASE WHEN city = “San Francisco“ THEN “California“ ELSE cityEND;
B
CREATE FUNCTION combine_california (city STRING)RETURNS STRINGCASE WHEN city = “San Francisco“ THEN “California“ ELSE cityEND;
C
CREATE FUNCTION combine_california (city STRING)RETURNS STRINGRETURN CASE WHEN city = “San Francisco“ THEN “California“ ELSE cityEND;
D
CREATE FUNCTION combine_california (city STRING)RETURN CASE WHEN city = “San Francisco“ THEN “California“ ELSE cityEND;
E
