1. 查询本月交易金额最高的卡号
select DISTINCT cardID from transinfo where transMoney=(select ... from ...)
2.查询挂失账号的客户信息
使用子查询N或内连接查询INNER join
select ... from userinfo where customerID IN(select ... from ...)
3.select cardID from tradeInfo where tradeMoney=
(select MAX (tradeMoney) from tradeInfo
where MONTY(tradeDate)=MONTH(now())
AND YEAR(tradeDate)=YEAR(NOW()));