Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
A view named recent_orders is created with the following SQL code:
CREATE VIEW 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.
What describes the results when querying recent_orders?