CREATE TABLE t1 ( no INT PRIMARY KEY ,country VARCHAR(20) ,capital VARCHAR(20) ); INSERT INTO t1 VALUES (1,'Japan','Beijing'); INSERT INTO t1 VALUES (2,'China','Canberra'); INSERT INTO t1 VALUES (3,'Australia','Bangkok'); INSERT INTO t1 VALUES (4,'Thailand','Bangkok'); INSERT INTO t1 VALUES (5,'Indonesia','Jakarta');