From: lucianodoc@luciano.doc   
      
   "Hugo Kornelis"  ha scritto nel   
   messaggio news:8iu3fcFfn1U1@mid.individual.net...   
      
   > SELECT   Nation,   
   >          SUM(CASE WHEN Value >= 0 THEN Value END),   
   >          COUNT(CASE WHEN Value >= 0 THEN Value END),   
   >          SUM(CASE WHEN Value < 0 THEN Value END),   
   >          COUNT(CASE WHEN Value < 0 THEN Value END)0   
   > FROM     YourTable   
   > GROUP BY Nation;   
      
   Great, thank you very much!   
      
   Luciano   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)