My solutions are attached. It is to be noted that the answers required were derived at the end of the summarize tool. all the tools used downstream of that are just to match the expected output. I don't know how beneficial it is learning-wise to simply rework the answers into an expected tabular format at the end. Regardless I used many tools to get the desired output even after I found the answers to the questions.