title: count(distinct request_ip) GROUP by date
body: <p>I have the following SQL, which I am using against AWS ELB logs stored in S3 with AWS Athena.</p>
  <pre><code>SELECT count(distinct request_ip) AS
   count,
   request_ip,
   DATE(from_iso8601_timestamp(timestamp)) AS date
  FROM &quot;default&quot;.&quot;aws_elb_logs&quot;
  WHERE request_ip = '10.0.2.1'
  GROUP BY request_ip, DATE(from_iso8601_timestamp(timestamp))
  </code></pre>
  <p>when i run the query, i get</p>
  <pre><code>request_ip  total   date
  1   10.0.2.1    1   2020-12-24
  2   10.0.2.1    1   2020-12-25
  </code></pre>
  <p>how do i count the total IPs and group these by date for a specific IP?</p>
  <p>any advise is much appreciated</p>