จำนวนสินค้าทั้งหมดที่อยู่ในคำสั่งซื้อที่มีสถานะ "ยกเลิก" คือเท่าใด
What is the total number of products that are in orders with status "Cancelled"?
df_customer_orders = pd.DataFrame(columns=['order_id', 'order_status']); df_order_items = pd.DataFrame(columns=['order_quantity', 'order_id'])
df_order_items[df_customer_orders[df_customer_orders['order_status'] == 'Cancelled']['order_id'].isin(df_order_items['order_id'])]['order_quantity'].sum()