แสดงชื่อลูกค้าที่สั่งซื้อพร้อมวิธีจัดส่ง FedEx และสถานะการสั่งซื้อ ชำระเงินแล้ว
Show the names of customers having an order with shipping method FedEx and order status Paid.
df_customers = pd.DataFrame(columns=['customer_name', 'customer_id']); df_customer_orders = pd.DataFrame(columns=['customer_id', 'shipping_method_code', 'order_status_code'])
df_customers[df_customers['customer_id'].isin(df_customer_orders[(df_customer_orders['shipping_method_code'] == 'FedEx') & (df_customer_orders['order_status_code'] == 'Paid')]['customer_id'])]['customer_name']