The shipping team wants to identify which orders qualify for free delivery, using data from the orders table.
Delivery is free for orders within India (country = 'IN') when the order value is at least 50 or the customer is a member. International orders always require paid delivery, regardless of order value or membership. A missing is_member value means the customer is not a member.
Label every order as free or paid.
Ordering: Sort by order_id in ascending order.