CREATE TABLE customers (id int, name varchar(10), age int); CREATE TABLE orders (id int, cid int, d date, amount double); insert into customers values(1,'Chris',25), (2,'John',20), (3,'Martin',30); insert into orders values(1,3,'2014-05-11',30.50), (2,1,'2013-06-21',21.45), (3,2,'2013-08-10',126.57), (4,1,'2014-10-11',29.36), (5,3,'2014-12-12',210.03),(6,2,'2015-01-15',27.45), (7,2,'2014-06-25',3.65), (8,1,'2013-06-21',21.45); analyze table customers compute statistics for columns; analyze table orders compute statistics for columns;