title: How to find the number of daily active users on an app for a given date range?
body: <p>I have this table in MySQL.</p>
  <p>*<em>user_id  event_date_time  Event</em></p>
  <p>7494212  1535308430      Opened app</p>
  <p>7494212  1535308433      Closed app</p>
  <p>1475185  1535308444      Registered</p>
  <p>6946725  1535308475      Opened app</p>
  <p>6946725  1535308476      Made a purchase</p>
  <p>6946725  1535308477      Closed app</p>
  <p>This has millions of rows where event date time is in unix timestamp format.</p>
  <p>I need to find the number of daily active users and monthly active users for the month of July-19. I tried the below mentioned query but it is not working in MySQL. Please help.</p>
  <pre><code>SELECT * FROM event_log; WHERE event_date_time BETWEEN 2014-07-01 00:00:00' AND '2019-07-31 23:59:59'
  </code></pre>