编辑代码

CREATE TABLE TABLE1
(
STOCK  varchar(20),
SYMBOL char(6),
SHARETYPE  char(1),
TRADEDATE date,
PRICE  decimal(10,2)
);
INSERT INTO TABLE2(STOCK,SYMBOL,SHARETYPE,TRADEDATE,PRICE) VALUES ('平安银行','000001','A','2021-05-20', 69.97);
INSERT INTO TABLE2(STOCK,SYMBOL,SHARETYPE,TRADEDATE,PRICE) VALUES ('长安B','200625','B', '2021-05-20', 7.11);
INSERT INTO TABLE2(STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE) VALUES('ST星源',000005, 'A', 1.82, '广东省'); 
INSERT INTO TABLE2(STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE) VALUES('北京城乡',600861, 'A', 14.38, '北京市') ;
INSERT INTO TABLE2(STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE) VALUES('三环集团',300408, 'A',37.41, '广东省') ;
INSERT INTO TABLE2(STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE) VALUES('万科A',000002, 'A',26.77, '广东省') ;
INSERT INTO TABLE2(STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE) VALUES('南玻B',200012, 'B',3.58, '广东省') ;