A table named recent_orders is created 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
)

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. What describes the results when querying recent_orders?