SELECT * FROM user c ,card d where c.userId=d.userId and name='李峰'
SELECT * FROM user c ,card d where c.userId=d.userId and cardNo=001
SELECT name,personId FROM user c ,card d where c.userId=d.userId and money>10000 GROUP BY name
SELECT name,money FROM user c ,card d where c.userId=d.userId and credit>400
SELECT city, sum(money) from user c ,card d where c.userId=d.userId GROUP BY city ORDER BY city DESC SELECT * from user c ,card d where c.userId=d.userId and openDate>'2019-01-00' and openDate<'2019-03-02' SELECT * from user c ,card d where c.userId=d.userId and money>20000 and city='北京' SELECT sex ,avg(money) from user c ,card d where c.userId=d.userId GROUP BY sex SELECT city,count(cardNo) from user c ,card d where c.userId=d.userId and isLock='0' GROUP BY city SELECT name,SUM(money) from user c ,card d where c.userId=d.userId GROUP BY name SELECT avg(MONEY),city FROM user c ,card d where c.userId=d.userId GROUP BY city HAVING avg(MONEY)>10000