title: Date split in columns in mysql
body: <p>I have an events executed table wherein I want to separate columns based on the dates</p>
  <pre><code>SELECT Event_ID,Name,count(Customer_Id) FROM UNLIMITED.Event_Execution a
  join UNLIMITED.Event_Master b on a.Event_Id=b.ID
  Where Event_Execution_Date_ID = '20211007'
  group by Event_Id
  order by Count(Customer_Id) desc;
  </code></pre>
  <p>Desired output</p>
  <pre><code>Event_ID  Name    20211006  20211007
  1         Offer1    1,218     6,876
  2         Offer2   10,212     4,123
  </code></pre>