A table is registered with the following databricks video

data-engineer-professional video for a table is registered with the following code: CREATE TABLE recent_orders AS ( SELECT a . user_id , a . email , b .

Full Certification Question

A table is registered with the following code: CREATE TABLE recent_orders AS ( SELECT a . user_id , a . email , b . order_id , b . order_date FROM ( SELECT user_id , email FROM users ) a INNER JOIN ( SELECT user_id , order_id , order_date FROM orders WHERE order_date >= ( current_date () - 7 )) b ON a . user_id = b . user_id ); Both users and orders are Delta Lake tables. Which statement describes the results of querying recent_orders?