title: SQL to print the result in below format
body: <p>I have an application where we use AWS Athena. I have 2 tables viz. events and event_transactions. events table contain event information and event_transactions contain individual events and there is a column event_date which tells the day on which event occurred.</p>
  <p>I need to calculate the count of events for each event for last 1 month interval, last 1 week interval and last 1 day from today's date.</p>
  <p>Format:</p>
  <pre><code>event_name, daily_count, weekly_count, monthly_count
  </code></pre>
  <p>I need to display all 3 counts for each event in the same row.</p>
  <p>To calculate weekly_count I use below query:</p>
  <pre><code>select event_name, count(*) as weekly_count from event_transactions where event_name in ('ABC','XYZ')
  and (event_date &gt;= CAST(current_date - interval '7' day as varchar)) AND (event_date &lt;= CAST(current_date - interval '1' day as varchar)) 
  group by 1
  </code></pre>
  <p>Output:</p>
  <pre><code>event_name.    weekly_count
  ABC.           23
  XYZ.           14
  </code></pre>
  <p>How can I write a SQL query which will print all 3 counts in a single row?</p>