Question 10: Questions: Find the first names of players whose names s…

1a. SELECT FirstName FROM Player WHERE FirstName LIKE 'A___%';
2b. SELECT FirstName FROM Player WHERE FirstName LIKE 'A___';
3c. SELECT TeamID, COUNT(PlayerID) FROM Player GROUP BY PlayerID;
4d. SELECT TeamID, COUNT(PlayerID) FROM Player GROUP BY TeamID;
5e. SELECT distinct t.TeamName FROM Team t INNER JOIN Player p
6   ON t.TeamID = p.TeamID WHERE p.LastName = 'Smith';
7f. SELECT distinct t.TeamName FROM Team t, Player p WHERE t.TeamID = p.TeamID
8   AND p.LastName = 'Smith';