You are tasked with creating a table in Snowflake to store customer order data. You need to ensure that the 'order date' column always defaults to the current date if no value is provided during inser

You are tasked with creating a table in Snowflake to store customer order data. You need to ensure that the 'order date' column always defaults to the current date if no value is provided during insertion. Additionally, you want to enable automatic clustering on the 'customer id' column to optimize query performance for order retrieval by customer. Which of the following SQL statements correctly date DATE DEFAULT CURRENT DATE) ORDER BY (customer_id); achieves this?