AVG() in small groups

How do you use the AVG api in sql to manage grouped output? For example:
Given a SQL Table “Employee”



Name Salary City

John Doe 15000 Seattle
Jane Doe 30000 Redmond
Tim Wayne 25000 Seattle


Write a SQL query that would return the average salary per city in the format shown below:



City Salary

Seattle 20000
Redmond 30000



Select City, AVG(Salary) from Employee where ... I don't know the rest

Where city == city or something like that?

i don't think you need a WHERE clause -- use the GROUP BY clause

Do you mean something like this?


select city
,avg(salary) as avgsalary
from employee
group by city

what happened when you tested that?