want the query for grouping the salary in each department and display if >30K

Emp table has EmoID , FirstName , LastName , MangerId , Salary , HierDate

Department Table Has DeptId , DeptName

I Want The query for Grouping the salary in each dept and display if its > 30k

Assignment?

It is a simple query, what have you got so far?.

so whats the answer for this 1 ???

i didnt get the answer