Answers for "group by is always tied together with an aggrigate function in sql"

group by is always tied together with an aggrigate function in sql

SELECT SUBJECT, YEAR, Count(*)
FROM Student
GROUP BY SUBJECT, YEAR;

group by is always tied together with an aggrigate function in sql

SELECT NAME, SUM(SALARY) FROM Employee 
GROUP BY NAME
HAVING SUM(SALARY)>3000;