The purpose of this exercise is to understand an applicants ability to problem solve, think critically, and write software with existing RIMdev team members. While there is no expected answer, we do expect the production of a working sample. That means the work must compile, transpile, or interpret and above all else run with no immediate exceptions.

While accomplishing this exercise is permitted before interviewing at Ritter Insurance Marketing, it may also be completed in collaboration with the interviewers.

You, as the interviewee, are encouraged to:

1. Ask Questions
2. Search the internet
3. Discuss your technical choices with interviewers

NOTE: The desired outcome is a pull request to this repository that builds and can be run by interviewer with minimal effort.

We also do not expect to see build artifacts in your pull request.

We expect the task to take anywhere between 45 to 90 minutes.

• GitHub account (personal or anonymous is fine)
  • Please inform team members which PR is yours in the case an anonymous account is utilized

• .NET (C#)

• Import data.json into memory
• Submit an application that answers the following questions about the data set:
  • What is the count of individuals over the age of 50?
  • Who is last individual that registered who is still active?
  • What are the counts of each favorite fruit?
  • What is the most common eye color?
  • What is the total balance of all individuals combined?
  • What is the full name of the individual with the id of 5aabbca3e58dc67745d720b1 in the format of lastname, firstname?

• Persist the result set to a database (of your choice)
• Include documentation for your technical choices
  • documentation may be in the form of comments or a markdown file
• Credit any packages and sources that helped you solve