Example Snowflake CTE query

example_cte_query.sql

with sample_data as (
    select *
    from snowflake_sample_data.tpch_sf1.customer
),

nation_14_customers as (
    select *
    from sample_data
    where c_nationkey = 14
),

nation_9_customers as (
    select *
    from sample_data
    where c_nationkey = 9
)

select *
from nation_14_customers
union all
select *
from nation_9_customers