Snowflake Select: Reads the data from the Snowflake source database.
Router: Categorizes the sales by marital status (single, divorced, undeclared).
Union: Groups the data by into these categories.
Filter: Filters out the data for inputs 1 and 2 (single and divorced) by state.
Aggregate: Performs aggregate operation to obtain average for sales, quantity, and wholesales with the sum of all wholesales.
Snowflake Insert: Writes the resulting data back to the Snowflake data warehouse.