title: How to use CURDATE() as column name
body: <p>HERE IS MY QUERY ( It doesn't work.)</p>
  
  <pre><code>SELECT 
    SUM(last_access_date &gt; CURDATE() and last_access_date &lt; CURDATE()+1) as CURDATE(),
    SUM(last_access_date &gt; CURDATE()-1 and last_access_date &lt; CURDATE()) as CURDATE()-1,
    SUM(last_access_date &gt; CURDATE()-2 and last_access_date &lt; CURDATE()-1) as CURDATE()-2,
    SUM(last_access_date &gt; CURDATE()-3 and last_access_date &lt; CURDATE()-2) as CURDATE()-3,
    SUM(last_access_date &gt; CURDATE()-4 and last_access_date &lt; CURDATE()-3) as CURDATE()-4,
    SUM(last_access_date &gt; CURDATE()-5 and last_access_date &lt; CURDATE()-4) as CURDATE()-5,
    SUM(last_access_date &gt; CURDATE()-6 and last_access_date &lt; CURDATE()-5) as CURDATE()-6
  FROM MYTABLE
  </code></pre>
  
  <p>I Want to see like that.</p>
  
  <p><a href="https://i.stack.imgur.com/usupv.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/usupv.jpg" alt="enter image description here"></a></p>