title: How to use LISTAGG in AWS Athena?
body: <p>I want to use LISTAGG for querying in Amazon Athena.
  Are there any ways to aggregate data into list or string?</p>
  
  <p>As <a href="http://docs.aws.amazon.com/athena/latest/ug/athena-ug.pdf" rel="noreferrer">Amazon Athena User Guide</a>,</p>
  
  <blockquote>
    <p>The grouping_expressions element can be any function (such as SUM, AVG, COUNT, etc.)</p>
  </blockquote>