SELECT contacts.state, bucket.name, count(*)
  FROM   contacts, bucket
  WHERE  contacts.indentifer BETWEEN bucket.begin AND bucket.end
  GROUP BY bucket.name, contacts.state
  ORDER BY contacts.state