Write a query that aggregates results, groups results, filters groups using the having function, and includes an appropriate column alias….

Write a query that aggregates results, groups results, filters groups using the having function, and includes an appropriate column alias. i. Book/Author: List the first and last name of each author and a count of how many books he or she has written, but only for the authors who have written more than one book. Name the count of books as “Book count” ii. Team/Player: List the team name and a count of the players on each team, but only for teams that have more than two players. Name the column of the number of players as “number of players” D. Write SQL statements that handle for nulls and convert data among the three major data types. i. Book/Author: Write a query listing all of the authors who have no social security number listed. For every author who has no social, replace the null with the words “No Social on File” ii. Team/Player: Write a query listing all of the players who have no social security number listed. For every player who has no social, replace the null with the words “No Social on File”