How to analyze the nature and frequency of customer transactions based on their age?

Question

SQL

Good day!
Tell me which way to dig. I think it needs 3 columns:

1. most popular store category
   
2. number of purchases per year
   
3. age
   

Answer 1

Any analysis must begin not with "I think" but with a clear statement of its (analysis) goal. What do you want to find out as a result? Or do you just want to "knock down" some of the stats you actually have? Well, for example, to identify whether the client's interests depend on his age. Even for such a simple question, it is clear that you have little data, and in order to get a more or less useful answer to the question, you must also enter a sign of the client's gender.
And since you wrote - well, this is not an analysis, it's just a relational database structure for performing one transaction. Yes, it is enough for your request, but then it is not clear, but what is the question?