UDFs and UDTFs — Question 3
Use the database TASTY_BYTES. Create a user-defined table function called menu_prices_below using the CREATE FUNCTION command. Have it take in an argument called price_ceiling of type NUMBER. Have it return TABLE (item VARCHAR, price NUMBER), and make the contents of the function the following: SELECT MENU_ITEM_NAME, SALE_PRICE_USD FROM TASTY_BYTES.RAW_POS.MENU WHERE SALE_PRICE_USD < price_ceiling ORDER BY 2 DESC When you run SELECT * FROM TABLE(menu_prices_below(3)); what is the item you see repeated multiple times in Results?
Deze oefening maakt deel uit van de cursus
Intro to Snowflake for Devs, Data Scientists, Data Engineers
Interactieve oefening met praktijkervaring
Zet theorie om in actie met een van onze interactieve oefeningen
Begin oefening