删除数据

按如下要求写出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 selevt 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('上海','长沙','深圳');