avg() in a small group

• • Reply

  9 months ago

  by Complete

  William Thompson

  , United States

  Joined 7 years ago

  How do you use AVG 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?

  Report abuse