customer_id customer_name customer_city avg_profit 101 Liam New York 25000 102 Josh Atlanta 22000 103 Sean New York 27000 104 Evan Toronto 15000 105 Toby Dallas 20000 supplier_id supplier_name supplier_city 501 ABC INC Dallas 502 DCX LTD Atlanta 503 PUC ENT New York 504 JCR INC Toronto order_id customer_id supplier_id order_date order_amount 401 103 501 2012-03-08 4500 402 101 503 2012-09-15 3650 403 102 503 2012-06-27 4800 404 104 502 2012-06-17 5600 405 104 504 2012-06-22 6000 406 105 502 2012-06-25 5600 customer_name Liam Josh Sean