title: Oracle Apex count and display number of entries in a column
body: <p>I have a table in Oracle Apex populated with contacts and their information.  On the dashboard of my app, I'd like it to say how many contacts are in the database using the big list of values plug-in or something like that.  I'm using the following code:</p>
  
  <pre><code>select contact_ID, count(*)
  from
  contacts
  group by contact_id
  </code></pre>
  
  <p>However all I'm getting is the number of times each specific contact appears in the table (which is 1), instead of the total number of contacts.  I understand what I did wrong in the code, but I'm not sure how to fix it.</p>
  
  <p>For further information, the table columns are very basic, just 'Name', 'contact_id'  (the primary key), 'Phone_Number', and so on.  The table is called CONTACTS.</p>
  
  <p>I'm also looking to eventually have the total number of organizations and comments on the dashboard as well.</p>
  
  <p>Thanks!</p>