SQLTeam.com | Weblogs | Forums

I am having trouble getting an answer to this question because the age function needs to be use in group by clause and i dont know the way to do that

Write a query using the salaries table to get the employees (two columns: emp_no, average salary) whose average salary is greater than 60000.

Order the output by salary from largest to smallest.

I mean the average function

Can someone please hlp to figure out this query i would be very thankful for it.

SELECT emp_no, [average salary]
FROM "the salaries table"
WHERE [average salary] >= 60000
ORDER BY [average salary] DESC

You filter data in the WHERE statement.

You can use the ORDER BY statement with ASC and DESC to sort