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?
Diese Übung ist Teil des Kurses
<Kurs>Intro to Snowflake for Devs, Data Scientists, Data Engineers</Kurs>Interaktive praktische Übung
Verwandle Theorie mit einer unserer interaktiven Übungen in die Praxis
Übung starten