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

Example 1: 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;

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

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