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

From: T3 <c.maradey2_at_verizon.net>
Date: 22 Dec 2005 13:32:39 -0800
Message-ID: <1135287159.538117.313340@g47g2000cwa.googlegroups.com>

Oops,

forgot the Totaled sales amount

  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],
         SUM(DECODE(SOLD,-1,amount,0)amount) AS Totaled,

    FROM leads , salesman
   WHERE leads.salesman = salesman.salesman GROUP BY leads.salesman; Received on Thu Dec 22 2005 - 15:32:39 CST