You are working with a Delta Lake table 'orders' that contains columns 'order_id', 'customer_id', and 'order_date'. You need to create a new table 'recent_orders' that includes only the orders from the last 30 days. Write the Spark SQL query to achieve this.

Simulated

CREATE TABLE recent_orders AS SELECT * FROM orders WHERE order_date >= current_date() - interval 30 days*_

48.6%

CREATE TABLE recent_orders AS SELECT * FROM orders WHERE order_date >= date_sub(current_date(), 30)*

19.2%

CREATE TABLE recent_orders AS SELECT * FROM orders WHERE order_date >= add_months(current_date(), -1)*

10.5%

CREATE TABLE recent_orders AS SELECT * FROM orders WHERE order_date >= date_add(current_date(), -30)*

21.7%

Databricks Certified Data Engineer - Associate