兩句好用既SQL insert into ... select ... , create ... as select ...

[insert into ... select ... ]
=================
INSERT INTO Store_Information (store_name, Sales, Date)
SELECT store_name, Sales, Date
FROM Sales_Information
WHERE Year(Date) = 1998

[create ... as select ]
==============
create table t1 as
select
store_name,
avg(quantity) qty
from
store join sales using (store_key)
group by store_name;