Analyze Data

[Parra]

I have a query that gives me the revenue each client has generated by week.

Using the current week of clients, I would like to know.
The percentage of new clients.
The percentage who have purchased in the previous 1, 2, 3, 6 months and finally year.

Any suggestions?

Thank you.