CommencerCommencez gratuitement

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?

Cet exercice fait partie du cours

<cours>Intro to Snowflake for Devs, Data Scientists, Data Engineers</cours>
Voir le cours

Exercice interactif pratique

Transformez la théorie en action avec l’un de nos exercices interactifs

Commencer l’exercice