Nested Conditions and Complex Logic

Use the following examples to apply complex and nested filtering:

-- Complex business rule validation with multiple conditions

    missing_count(shipping_address) = 0

-- Filter:

    (order_type = 'PHYSICAL' AND shipping_method != 'PICKUP') OR (customer_tier = 'PREMIUM' AND order_amount > 500)