Engineering homework help. 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