完成以下功能:
select card.*from card,user where name='李峰'and `user`.userId=card.userId;
select user.* from card,user where cardNo='001'and card.userId=`user`.userId
select `user`.`name`,`user`.personId from card,user where money>10000 and card.userId=`user`.userId;
select `user`.`name`,card.money from card,user where credit>400 and card.userId=`user`.userId;
select city,sum(money) c from card,user where card.userId=`user`.userId GROUP BY city ORDER BY c ;
select user.* from card,user where openDate BETWEEN '2019-01-01' and '2019-03-01' and `user`.userId=card.userId;
select user.* from card,user where city='北京'and money>20000 and `user`.userId=card.userId;
select user.sex,AVG(money) from card,user GROUP BY user.sex
select city,count(cardNo) from card,user where card.isLock='0' and `user`.userId=card.userId GROUP BY city ;
select `user`.`name`,sum(money) from card,user where `user`.userId=card.userId GROUP BY `user`.`name`;
select city from card,user where `user`.userId=card.userId GROUP BY city HAVING AVG(money)>10000;