title: Assign custom labels to sql query
body: <p>This is a pretty simple question, I think, but I cannot find an answer for it here, or through online searching.</p>
  
  <p>I am running a count query, and am having trouble with value labels and column headings</p>
  
  <p>Query is</p>
  
  <pre><code>SELECT
  mail_code AS "code",
  COUNT(mail_code) AS "count"
  FROM data.base
  GROUP BY mail_code
  ;
  </code></pre>
  
  <p>I get back:</p>
  
  <pre><code>C       Count
  -       -----
  Y       110
  X       785
  Z       92
  </code></pre>
  
  <p>Questions:</p>
  
  <ol>
  <li>How do I get the first variable (code) to display its full name, instead of a single letter?</li>
  <li>How do I change Y, X, and Z to read "phone," "mail," and "email" ...or anything else for that matter?</li>
  </ol>
  
  <p>The length of the mail_code variable is 1 byte...is that why only the first letter is showing up as my varname?</p>
  
  <p>...I was initially warned that based on my title, it might get downvoted. OK, but I tried to look elsewhere for the answer and could not find it, IE I tried due diligence. </p>
  
  <p>Thank you in advance.</p>