1
2
DROP TABLE if exists customers ;
CREATE TABLE customers (customer_id int, customer_name varchar(255), customer_city varchar(255), avg_profit int);
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Run (Ctrl-Enter)
-
Output -
Runtime error -
Build error -
Input
(0.98 sec)
0
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