In a scenario where you are tasked with analyzing customer orders data stored in a DataFrame 'df' with columns 'customer_id', 'order_id', and 'order_date', your goal is to identify and count only the active orders, defined as those orders that have not been scheduled for a future date. Considering the importance of accurately filtering out future orders to ensure the integrity of your analysis, which of the following Spark SQL queries correctly creates a Common Table Expression (CTE) named 'active_orders' that filters out orders with a future order_date, and then uses the CTE to count the number of active orders? Choose the best option from the four provided below.