I want to know when my application is the most used per hour and per day for comparative purposes for marketing. I can do it with the PostgreSQL database but the problem is that I do not know how to segment the results by hour and day.
I have two tables:
Here is the table
How to know how many times we have
swipe.state=3, 6 o 9 per hour per week ordered in decreasing order?