直接用两次insert into 不行么？
insert into store_information values ('Los Angeles','$1500','1999-01-05');
insert into store_information values ('Los Angeles','$300','1999-01-01');

SELECT DISTINCT STORE_NAME, Sales, Date From (TABLE NAME)

谢谢，可以的，我当时糊涂了。