删除数据

按如下要求写出sql语句：

1. 删除所有银行卡信息
2. 删除所有北京客户的客户信息
3. 删除所有上海，长沙，深圳的客户信息
4. 将交易表的数据截去
5. 删除2019年6月，所有的交易记录
6. 删除在交易表中没有交易的记录的银行卡信息
7. 删除所有年龄大于30岁的客户信息
8. 删除所有男性客户的交易记录
9. 删除所有女性客户的银行卡信息
10. 删除交易表中，第3-6条记录

DELETE FROM transinfo WHERE transDate rlike '2019-06.'
delete from card where cardNo not in (select distinct cardNo from transinfo)
delete from transinfo where cardno in
(select cardno from card ,user where card.userId=user.userld and sex='男')
TRUNCATE  TABLE transinfo
delete from card where userIder in
(select user.userId from user WHERE sex='女')
TRUNCATE  TABLE transinfo
 delete from user where name in
(select name from `user` where substring(personId,7,4)<'1991')
DELETE FROM user WHERE city='北京'
DELETE FROM user WHERE city='上海' AND city='长沙' AND city='深圳'