ANY answer.
Re: Stuck with a query question
Customers.......TotalSpending
Cust.1............$2300
Cust.2............$1100
etc.................etc...
select customers , TotalSpending
from CustomerValues
where TotalSpending > (select 0.8* sum(TotalSpending)
from customerValues);
|