SELECT * FROM TABLE(mysql.system.query( query => 'with customers_who_ordered as (select distinct custkey from tpch.orders) select custkey, name from tpch.customer where custkey not in (select * from ...
--A Case Statement allows you to add logic to your Select Statement, sort of like an if else statement in other programming languages or even things like Excel ...