Using SQL calculate average value on each sector

Can you please help me , on how to calculate the average value of the returns on each sector.

**Excepted Output **

This is what I have tried – But I don’t see the expected result

create table table1
(
Stocks varchar(20),
Returns decimal(10,2),
Sector varchar(100)
)

INSERT INTO table1 (Stocks,Returns,Sector) VALUES ('MS','2','IT')
INSERT INTO table1 (Stocks,Returns,Sector) VALUES ('APPL','5','IT')
INSERT INTO table1 (Stocks,Returns,Sector) VALUES ('GEICO','8','IT')
INSERT INTO table1 (Stocks,Returns,Sector) VALUES ('PETRO','10','OIL')
INSERT INTO table1 (Stocks,Returns,Sector) VALUES ('BP','7','OIL')
INSERT INTO table1 (Stocks,Returns,Sector) VALUES ('Citiz','10','ENERGY')
INSERT INTO table1 (Stocks,Returns,Sector) VALUES ('Utility','4','ENERGY')

select Stocks,AVG(Returns) as 'Returns',Sector from table1 group by Stocks,Returns,Sector

>Solution :

You can do it using inner join to join the list of averages by sector

select t.Stocks, s.average, t.Sector
from table1 t
inner join (
  select Sector, AVG(Returns) as 'average'
  from table1 
  group by Sector
) s on s.Sector = t.Sector
order by Sector

Demo here