Re: Challenging SQL Query Problem. Can you solve it?

X-No-Archive:yes

T3 wrote:
>
> After looking at both your queries I think it's best if you just
> combine them into one that sums both sold and lost for each
> salesperson. I think this will work for you.
>
> SELECT leads.salesman AS Salesperson,
> COUNT(DECODE(LOST,-1,1,0)) AS [Number of Lost],
> COUNT(DECODE(SOLD,-1,1,0)) AS [Number of Sales]
> FROM leads , salesman
> WHERE leads.salesman = salesman.salesman
> GROUP BY leads.salesman;
>
> I do not have the tables to run but am pretty sure it will work for
> you.
>

Thank you for your response. Is there any way to do it without the DECODE? My DBMS doesn't have DECODE unfortunately.

Thanks,

karen Received on Thu Dec 22 2005 - 15:45:39 CST