title: selecting multiple columns but group by only one in postgres
body: <p>I have a simple table in postgres:</p>
  
  <pre><code>remoteaddr        count
  142.4.218.156     592
  158.69.26.144     613
  167.114.209.28    618
  </code></pre>
  
  <p>Which I pulled using the following:</p>
  
  <pre><code>select remoteaddr,
  count (remoteaddr)
  from domain_visitors
  group by remoteaddr
  having count (remoteaddr) &gt; 500
  </code></pre>
  
  <p>How do I select additional columns and still only group by <code>remoteaddr</code>?</p>