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 TeamsDavid Allan ( David ) Aardsma    $1,322,821.43                    7Donald William ( Don ) Aase       $575,000.00                       4Fausto Andres ( Andy ) Abad      $327,000.00                       1

Leave a Reply