title: COUNT(*) AND LIST OF ITEMS IN COUNT SQL
body: <p>I have a table like this</p>
  
  <pre><code>Acct_number    account_id 
  
  xxxx            1111
  
  xxxx            2222
  
  xxxx            3333
  
  
  
  SELECT DISTINCT acct_number
        ,count(account_id) 
  FROM account_table 
  GROUP BY acct_number;
  </code></pre>
  
  <p>How can I make my output be like this:</p>
  
  <pre><code>acct_number    count_acct_number    account_id
  
  xxxx                 3             1111, 2222 ,33333
  </code></pre>