title: SQL Count of different records having same name
body: <p>I am new to SQL so, I have a table that holds records for assigned jobs as for employee, holding hours required to complete the job.</p>
  
  <p>An employee might have a lot records, regarding to different jobs that was assigned. So what I want is to select all the employees and sum their hours assigned in total..</p>
  
  <p>I want an output to display each employee individually and the number of total hours assigned.</p>
  
  <p>Something like: <code>select username, Count(Hours) from mytable 
  group by username</code></p>
  
  <p>The query above obviously is not giving the expected output. </p>
  
  <p>Is there/what is the way to do that?</p>
  
  <p>Any help is welcome!</p>