7 lines
191 B
SQL
7 lines
191 B
SQL
select CUST_STATE as `State`, count(CUST_BALANCE) as `Number of non zero balances`
|
|
from LGCUSTOMER
|
|
where
|
|
CUST_BALANCE != 0
|
|
group by CUST_STATE
|
|
having
|
|
count(CUST_CODE) > 100; |