title: SQL distinct count from distinct rows?
body: <p>The following line of code gives me the time needed without duplicates, helping me avoid the actual dates.</p>
  
  <pre><code>    SELECT DISTINCT TO_CHAR(Start_Date_Time, 'HH:MI AM') AS StartTime
      FROM Section
      GROUP BY Start_Date_Time;
  </code></pre>
  
  <p>However, when I try to count the distinct course numbers in those specified times with the following code, the count adds duplicate start times in the rows.</p>
  
  <pre><code>    SELECT DISTINCT TO_CHAR(Start_Date_Time, 'HH:MI AM') AS StartTime, 
      COUNT(Course_No)
      FROM Section
      GROUP BY Start_Date_Time;
  </code></pre>
  
  <p>I do not want any duplicate start times. Any help on this would be much appreciated.</p>