create views whitout object with
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);
******
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);
******