按如下要求写出sql语句:
-- 1
create table user2
as
select * from user where false;
-- 2
insert into user2
(select * from user where city='北京')
-- 3
create table user3
( userid varchar(3),
name varchar(10),
money decimal(10,2),
primary key (userId)
);
-- 4
insert into user3
(select card.userId,name,money from card ,user where card.userId=user.userld)
-- 5
create table user4
as
select * from user where sex='男'
-- 6
insert into card
values('010',now(),10000,'091515',0,'101');
-- 7
insert into transinfo(transDate,cardNo,type,money,remark)
values(now(), '003', '转出', 500, '微信')