sql语句如何实现如下的条件查询需求

SELECT SUM(Account) 
FROM account
WHERE State='00'

SELECT COUNT(property) 
FROM custinfo
WHERE Property = '2'

SELECT * 
FROM custinfo ,account 
WHERE custinfo.`CustId`=account.`CustId` AND Property='1' AND State='00'

SELECT SUM(Account)
FROM custinfo,account
WHERE custinfo.`CustId`=account.`CustId`
GROUP BY property

SELECT *
FROM custinfo,account
WHERE custinfo.`CustId`=account.`CustId`
GROUP BY property

SELECT custinfo.`CustId`,account.`CustName`,SUM(Account)
FROM custinfo,account
WHERE custinfo.`CustId`=account.`CustId` AND custinfo.`Property`='1' 
GROUP BY custinfo.`CustId`
HAVING SUM(Account)>5000000

这么多问题，3个牛币

SELECT SUM(Account) 
FROM account
WHERE State='00'

SELECT COUNT(property) 
FROM custinfo
WHERE Property = '2'

SELECT * 
FROM custinfo ,account 
WHERE custinfo.`CustId`=account.`CustId` AND Property='1' AND State='00'

SELECT SUM(Account)
FROM custinfo,account
WHERE custinfo.`CustId`=account.`CustId`
GROUP BY property

SELECT *
FROM custinfo,account
WHERE custinfo.`CustId`=account.`CustId`
GROUP BY property

SELECT custinfo.`CustId`,account.`CustName`,SUM(Account)
FROM custinfo,account
WHERE custinfo.`CustId`=account.`CustId` AND custinfo.`Property`='1' 
GROUP BY custinfo.`CustId`
HAVING SUM(Account)>5000000

这是在笔试？面试？

快下班了，能写多少就多少吧！

1.select sum(amount) from account

2.select count(c.custid) from custinfo c left join account ac on c.sustid = ac.custid where c.property = '1' group by c.custid

3.select ac.* from custinfo c left join account ac on c.sustid = ac.custid where c.property = '2' and ac.state = '00'

4.select count(id),sum(amount) from account group by state

5.select ac.custid,ac.custname,sum(amount) from custinfo c left join account ac on c.sustid = ac.custid where c.property = '2' group by c.custid having sum(amount)>5000000

盲写的  不保证正确率

顺便说下，并不喜欢 from 的表 用 逗号链接~

笛卡尔乘积 表示驾驭不了~