开始使用免费开始使用

UDFs and UDTFs — Question 2

Use the database TASTY_BYTES. Create a function called min_menu_price using the CREATE FUNCTION command. Have it return the data type NUMBER(5,2), and make the contents of the function the following: SELECT MIN(SALE_PRICE_USD) FROM TASTY_BYTES.RAW_POS.MENU. When you run SELECT min_menu_price(); what is the column name and the value that you see in the Results?

本练习是课程的一部分

Intro to Snowflake for Devs, Data Scientists, Data Engineers

查看课程

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习