Re: SQL sentence

MĒ Carmen Lozano wrote:

> Can somebody help me?

COUNT(CASE...WHEN...END) must be applied to CODE column in order to generate n pseudocolumn, one for each different value of CODE you wish to count.

You must group results by CITY.

Kind regards,

-- 
Cris Carampa (cris119_at_operamail.com)
"E` evidente che siamo di fronte allo sfruttamento opportunistico
  di quella quota di astensioni fatalmente derivanti da disinteresse
  o indifferenza." (Gustavo Zagrebelsky)