Snowflake query explainer

Explain and understand query for Snowflake.