Snowflake Interview Question

What is a CTE and why would you use one?