title: MySQL rename column
body: <p>This is a homework question I had but I just wasn't sure if I got the correct answer. The question was:</p>
  
  <p>Write a SQL statement to count the number of rows in the relation R(A, B, C) and rename the result column as num</p>
  
  <p>My answer:</p>
  
  <pre><code>COUNT(*) AS num
  </code></pre>
  
  <p>Is this correct or do I have to use ALTER?</p>