create views whitout object with

Job ID: 32163725

Budget: $10 – $30 USD

I need to create views with the tables I have, but without the object with:
Example:
I have this:
******
WITH salario_division AS (
SELECT division,
AVG(salario) salario_medio
FROM empleados
GROUP BY division )
SELECT division,
salario_medio
FROM salario_division
WHERE salario_medio > (
SELECT AVG(salario_medio) * 1.1
FROM salario_division )
ORDER BY salario_medio;
*******

now I need this:
*******
SELECT division,
AVG(salario) salario_medio
FROM empleados
GROUP BY division
HAVING AVG(salario) > (
SELECT AVG(salario) * 1.1
FROM empleados )
ORDER BY AVG(salario);
******
Related categories: SQL MySQL PostgreSQL Programming