Draft a document outlining your solution to answer the following questions. This document must contain the Hive query language (HQL) commands, names of the data file(s) that you will need to include in the queries and the results that you expect to get from the queries. NOTE : The HQL commands look similar to SQL queries.

What is the total number of baseball players? How many players were born before 1960? How many players were born after 1960? How many players were born in the USA? How many players were born outside the USA? Group the number of players by year of birth and then only list the top 10 years List the number of players by month of birth Provide a list of players with the following information: Provide a list of players with his age as of today (NOTE: You can use just the birth-year column) Provide a list of players that were inducted into the Hall of Fame Provide a list of all players for any team and from any year. For example, print the list of players who played for Chicago Cubs in 2000.