staging_orders.order_date_text mixes two formats from two source systems: YYYY-MM-DD (2026-05-01) and US-style MM/DD/YYYY (05/02/2026).
Return order_date (a real DATE) and revenue (amount × qty, skipping amounts that aren't numbers), one row per day. Sort by order_date.