Question: a. For files changed, lines of code added, and lines of code deleted, show the total and average for all commits for each repository by

a. For files changed, lines of code added, and lines of code deleted, show the total and average for all commits for each repository by repository name. Only include commits authored in 2020. b. You're considering implementing a new reward system for productivity. Badges will be distributed based on a productivity score. Each line of added code is worth 5 points, each file changed is worth 10 points, and each line of deleted code is worth 1 point. The sum of these three values in a three month period is the productivity score. Calculate this score for each developer authoring changes between October and December 2020. Include the developer's name and sort by this column. c. Return the name of each developer who mentors another developer. Include the number of developers they mentor and the total number of commits they have authored. The results should show only developers who serve as a mentor, even if they have not authored a commit. Sort the results by the number of commits authored in descending order. d. For each repository, show it's name, the language it uses, and how old it is in months. Also show the number of commits and the number of committing developers for the repository. Sort from youngest to oldest repository. e. Find the developer who has been in the community for the shortest time and the one who has been in the community for the longest time. Return their names in addition to the following: For the newest developer, return the number of commits they have authored, as well as the number of files changed, additions, and deletions resulting from those commits. Also display the literal value 'as Author' in a column called DevRole. For the oldest developer, return the number of commits they have approved, as well as the number of files changed, additions, and deletions resulting from those commits. Also display the literal value 'as Committer' in a column called DevRole