Selectați interogarea , care extrage salariul mediu pentru fiecare departament in care activeaza mai mult de 20 persoane:

Question

Selectați  interogarea , care extrage salariul mediu pentru fiecare departament in care activeaza  mai mult de 20 persoane:

Accepted Answer

SELECT Departament, AVG(Salariu) AS Salariu_Mediu FROM functionari GROUP BY Departament  HAVING COUNT(*)> 20

Answer

SELECT Departament, COUNT(Salariu) AS Salariu_Mediu FROM functionari GROUP BY Departament  HAVING COUNT(*)> 20

Answer

SELECT Departament, AVG(Salariu) AS Salariu_Mediu FROM functionari GROUP BY Departament

Answer

SELECT Departament, SUM(Salariu) AS Salariu_Mediu FROM functionari GROUP BY Departament  HAVING COUNT(*)> 20

Answer

SELECT Departament, AVG(Salariu) AS Salariu_Mediu FROM functionari GROUP BY Departament  HAVING AVG(*)> 20

Crowdly