count depending on condition - Oracle
688373Apr 10 2009 — edited Apr 10 2009I want to count only rows which satisfy a particular condition.
I have several conditions but it needs to be one query. How would I do that?
ex:
select
count (no of days) where sales where below 100
count (no of days) where no of customers were below 100
from products
join customers
join sales