title: Inserting a GROUP BY result into another table
body: <p>I was migrating a field to a new table.  The new table has three fields.  What I tried was </p>
  
  <pre><code>INSERT INTO foo VALUES ('', (SELECT bar FROM baz GROUP BY bar), '');
  </code></pre>
  
  <p>This resulted in an error due to multiple rows resulting from the select.</p>
  
  <p>What is the right way to do this?</p>