How to use pseudo names with CONCAT and Mysql?

Question

A question about Mysql asks the result to exit in this answer format.

When finishing my solution through a consultation made on Mysql, find the following problem.

Below is a first example solution of my query that Works

SELECT CONCAT('There are a total of ' , COUNT(name),' ', occupation ) FROM OCCUPATIONS GROUP BY occupation ORDER BY COUNT(name) ASC ;

Below is a second solution example of my query that Doesn’t Work

SELECT CONCAT('There are a total of ' , COUNT(name) AS Numb,' ', occupation ) FROM OCCUPATIONS GROUP BY occupation ORDER BY Numb ASC ;`

The problem at issue is that I would like to rename the COUNT(name) for numb through a 'alias' or a pseudo name, but I’m faced with this mistake.

ERROR 1583 (42000) at line 3: Incorrect parameters in the call to native function 'concat'

It would be possible to circumvent this problem, that is, it is possible to use pseudo names within the function CONCAT?

Answer 1

It’s not possible, and in this case it doesn’t even make sense. I initially imagined that I would use the die for something else, as it would not be completely unnecessary to name the result of the expression used in concatenation.

It makes no sense not to want repetition because the syntax asks for repetition.

Answer 2

According to the standard it is not possible to use aliases in the same SELECT statement in which they are created. A solution is to use a sub-query.

The standard states that the sequence of execution of the instructions is as follows::

1. FROM 
2. WHERE
3. GROUP BY
4. HAVING
5. SELECT
6. ORDER BY
7. TOP

This explains, for example, why it is possible to use an alias in the ORDER BY clause.