For an `Employee` table with columns `EmpId`, `Name`, `Salary`, is it possible to write a SQL query so that the result contains each employee's name and the average salary of all employees?

**Sample Data** 

```
EmpId      Name       Salary 
 1         Alice       12000
 2         Bob         12000 
 3         Charlie     10000 
 4         Doug         6000 

```

I need a query which would return this result:

**Result**

```
Name       AvgSalary 
Alice      10000 
Bob        10000 
Charlie    10000 
Doug       10000 

```

Here 10000 is average salary of all the 4 employees.