title: Naming a group_concat column in a select
body: <p>sqlite3</p>
  
  <p>I have two tables.  One contains some lists and the other contains each list's items.</p>
  
  <p>I want to create a select statement that grabs the rows in the lists table, but also creates a column which is a comma-delimited summary of the items in each list.</p>
  
  <p>I have this working as follows:</p>
  
  <pre><code>select
      master._id as _id,
      master.name as name,
      master.created_on as created_on,
      group_concat(items.name, ', ')
  from
      tablea master
  join
      tableb items
  on
      master._id = items.master_id
  group by
      master._id
  </code></pre>
  
  <p>However, I would like to name the column returned by the group_concat as "summary" like so:</p>
  
  <pre><code>select
      master._id as _id,
      master.name as name,
      master.created_on as created_on,
      group_concat(items.name, ', ') as summary
  from
      tablea master
  join
      tableb items
  on
      master._id = items.master_id
  group by
      master._id
  </code></pre>
  
  <p>When I do this, I get an sql error:
  "SQL error: near "summary": syntax error</p>
  
  <p>How can I achieve what I'm wanting to do?</p>
  
  <p>I would also like to order the items in the group_concat alphabetically descending, but naming the column is my first priority.</p>