删除数据

按如下要求写出sql语句：

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

delete from transinfo where transDate BETWEEN '2019-06-01' and '2019-06-30'

delete from  card where card.cardNo not in(select distinct cardNo from transinfo )  

delete d from card d left join transinfo c on d.cardNo=c.cardNo where c.cardNo is null;

select cardNo from user,card where user.sex='男'and user.userId=card.userId;

delete from transinfo where transinfo.cardNo in (select cardNo from user,card where user.sex='男'and user.userId=card.userId)

truncate table transinfo

delete from card where userId in (select userId from user where sex='女' )

truncate table card

delete from user where  SUBSTR(personId,7,4)<'1991';

delete from user where city='北京'

delete from user where city in ('上海','长沙','深圳');