About SQL Function Examples

You need to use a FROM clause in Drill queries. You can use the VALUES clause in the FROM clause to define rows of data in a derived table. The derived table has statement level scope.