Handle Nulls in Large Joins

How would you handle null values when performing a join between two large tables?

Using the supplied orders and customer_accounts tables, write a query that preserves every order, avoids matching NULL customer keys, substitutes readable values for missing account attributes, and classifies each order's match status.

Output

1. One row per order with order_id, customer_id, customer_name, segment, and join_status.
2. Include matched orders, orders with NULL customer IDs, and orders with non-matching customer IDs.
3. Sort by order_id ascending.