title: Count number of ids by Month SQL
body: <p>I have a table like this, I hope to count the number of ids by month. I used the following code but it does not work.</p>
  <pre><code>id                  date_time
  1390880502018723840,2021-05-08
  1390881127930372100,2021-05-08
  1390881498270736386,2021-05-08
  
  </code></pre>
  <pre><code>SELECT   twitter.tweets.id
  WHERE    Month(twitter.tweets.date_time)=01 AND Year(twitter.tweets.date_time)=2021 ;
  </code></pre>