Write optimized PostgreSQL
Budget: $10 – $30 USD
Hi, I need optimized PostgreSQL queries, two. I have a .csv file with columns user_id and order_date. And I need to calculate % as below:
1. Find the percentage of users who placed more than 1 order in the FIRST 28 days (with output)
2. Find the percentage of users who has average days between orders over 28days (with output)
1. Find the percentage of users who placed more than 1 order in the FIRST 28 days (with output)
2. Find the percentage of users who has average days between orders over 28days (with output)
Related categories:
PostgreSQL