Mysql 高级（进阶）SQL 语句

use XXX;      

create table location(Region char(20),Store_Name char(20));

insert into location values(‘East‘,‘Boston‘);

insert into location values(‘East‘,‘New York‘);

insert into location values(‘West‘,‘Los Angeles‘);

insert into location values (‘West‘,‘Houston‘);

create table store_info(Store_Name char(20),Sales int(10),Date char(10));

insert into store_info values(‘Los Angeles‘,‘1500‘,‘2020-12-05‘);

insert into store_info values(‘Houston‘,‘250‘,‘2020-12-07‘);

insert into store_info values(‘Los Angeles‘,‘300‘,‘2020-12-08‘);

insert into store_info values(‘Boston‘,‘700‘,‘2020-12-08‘);