按如下要求写出sql语句:
-- 1
delete from transinfo2 where transDate between '2019-6-1' and '2019-6-30'
-- 2
delete from card2 where cardno not in
(select distinct cardno from transinfo)
-- 3
delete from transinfo2 where cardno in
(select cardno from card ,user where card.userId=user.userld and sex='男')
-- 4
truncate table transinfo2
-- 5
delete from card2 where userid in
(select `user`.userld from `user` where sex='女')
-- 6
truncate table card2
-- 7
delete from user where name in
(select name from `user2` where substring(personId,7,4)<'1991')
-- 8
delete from user where name in
( select name from `user2` where city = '北京')
-- 9
truncate table user2