title: SQL Query mishap
body: <p>New SQL'er here. Okay for a school assignment I decided to build the tables in the question so I can test my queries for correctness. </p>
  
  <p>One of the questions is simply show all employees that share the same office. Easy I think</p>
  
  <pre><code>SELECT office, name
   FROM my_db.employee
   GROUP BY office;
  </code></pre>
  
  <p>but when I run this it returns only the first tuple of each unique office not all grouped by office.</p>
  
  <p>Is something wrong with my logic?</p>