title: Query For Insert From Select Query
body: <p>I have a table named <code>tb_tweetkurator_test</code> and the query is:</p>
  
  <pre><code>SELECT id_user,
          COUNT(id_tweet) as JML_TWEET,
          COUNT(IF(url = 'yes', url, NULL)) as JML_TWEET_URL,
          COUNT(IF(mention = 'yes', mention, NULL)) as JML_TWEET_MENTION,
          COUNT(IF(retweet = 'yes', retweet, NULL)) as JML_TWEET_RETWEET,
          COUNT(IF(tweet_biasa = 'yes', tweet_biasa, NULL)) as JML_TWEET_BIASA
  FROM tb_tweetkurator_test
  GROUP BY id_user;
  </code></pre>
  
  <p>and the result is </p>
  
  <pre><code>id_user   | JML_TWEET | JML_TWEET_URL| JML_TWEET_MENTION | JML_TWEET_RETWEET | ML_TWEET_BIASA
  
  16912985  | 20        | 6            | 13                | 0                 | 3
  23343960  | 10        | 10           | 0                 | 0                 | 0
  46651600  | 20        | 9            | 17                |15                 | 2
  267164011 | 20        | 14           |10                 |4
  </code></pre>
  
  <p>What makes me confuse is, can I insert data above (from the <code>SELECT</code> query) into a new table?</p>