Using a scalar queries in the SELECT statement and the salaries and people tables , write a query that shows the full Name, the average salary and...

 Using a scalar queries in the SELECT statement and the salaries and people tables , write a query that shows the full Name, the average salary and the number of teams the player played.

Full Name                                          Average Salary                 Total Teams

David Allan ( David ) Aardsma    $1,322,821.43                    7

Donald William ( Don ) Aase       $575,000.00                       4

Fausto Andres ( Andy ) Abad      $327,000.00                       1