Question #261

CREATE TABLE users (
  id serial PRIMARY KEY,
  name varchar(100),
  city_name varchar(100),
  year integer
);

INSERT INTO users (name, city_name, year) VALUES
  ('Alex', 'Santiago', 1985)
  ,('Sam', 'Salvador', 2004)
  ,('Max', 'Lima', 1970)
  ,('Tom', 'Santiago', 2003)
  ,('Bob', 'Lima', 1970)
  ,('Ali', 'Salvador', 1999)
;

SELECT city_name, year
FROM users
WHERE year < 2000
GROUP BY city_name
ORDER BY year DESC;