Low Cost Dedicated Servers | Free IP’s | DDOS Protection | Monthly Billing!

Hostpoco.com always understands the needs of clients and hence always wish to design such plans which will be beneficial to our clients where they invest small bucks and can earn huge advantages. Dedicated servers with a monthly billing cycle are very much demanded services that everyone wants to buy. We offer this service with a low range of pricing with the free IPs too.

Also, we offer free server setup also offers freedom to clients to set up RDNS for their IPs. So if you need full authority and extensive control over your business environment and business sites then Dedicated servers are the most suitable option for you. Our dedicated servers not only provide full root SSH access but also offers full DDOS protection for the dedicated servers. Also, these unmanaged dedicated servers are most demanded and clients have the freedom to handle it as per their needs and requirement.

Features :

– Latest Dedicated Server configs
– 99.9% Uptime Guarantee
– 24/7 Live Support
– SSH Access-
– Unmanaged Servers
– Free Additional IP’s
– SSD/HDD Available
– Max Storage
– DDOS Protection
– Monthly Billing Cycle
– RDNS Facility

Hostpoco.com: Low-cost servers, Unmanaged Dedi server, Free IP servers, monthly billing servers, DDOS protected servers

To place an order or check more plans details visit https://www.hostpoco.com/low-cost-dedicated-server.php

If you have any questions about our services please send us an email at sales@hostpoco.com
We also have a live chat link on our website.

Monthly summary of active users based on a start/end date roster

I have a table that dictates who was on a project, from a startdate to an enddate. I’d like some help writing a query that will return the number of "active" users at the end of every month, for the past 12 months.

CREATE TABLE `roster` (   `id` int(11) NOT NULL,   `user_id` int(11) DEFAULT NULL,   `project_id` int(11) DEFAULT NULL,   `start_date` datetime NOT NULL,   `end_date` datetime NOT NULL,   `closed_date` datetime DEFAULT NULL,   PRIMARY KEY (`id`) ); 
id  user_id project_id  start_date  end_date    closed_date 1   1   1   2019-05-27 00:00:00 2021-02-01 00:00:00 NULL 2   2   2   2020-05-27 00:00:00 2021-02-01 00:00:00 2020-02-05 00:00:00 3   3   3   2020-05-27 00:00:00 2024-02-01 00:00:00 2020-02-05 00:00:00 

And the result would be something that shows how many distinct users had an active project within each month (only since the start of this year).

So for the dataset above, we can see that all 3 projects were "active" in the month January 2021, because the end date is in the future.

2020-01-31 | 3 

The last bit of complexity is that sometimes a project can be closed before the EndDate and I’d like to exclude any users who’s endDate is in the future but the project has actually closed.

For example in the dataset above, the third project has a end date of Feb 2024, however the project closed in Feb 2021. So technically the person was active in 2021 Jan and Feb, but not March.

p.s Hoping to get an answer in Postgres (I’m using Redshift)

[Hostpoco.com]*Cheap US VPS Hosting – 24/7 Support – 2 TB Monthly Traffic – free RDN

Hostpoco.com provides Cheap Reliable US-based VPS Hosting Starting from $14.99, All of our VPS plans come fully managed as well, no more worrying about how to set up and manage your VPS. Just Sign up and try our service. we will manage everything.

Website: https://hostpoco.com/
Email support: Sales@hostpoco.com

All VPS Plans Include

» Complete Root Access
» 24×7 Rescue System
» Premium Bandwidth
» 24/7 Fully Managed
» 99.9% Server Uptime Guarantee
» Free VPS Migration
» 30 Day Money Back Guarantee!
» SSH Access
» Free Setup
» IPv4 included

Our VPS Package

*VPS Startup
~ 1024 MB Memory
~ 30 GB Raid 10 Storage
~ 2 TB Monthly Traffic
~ 1 IP4 included
Starting $14.99/mo.

*VPS Pro
~ 2048 MB Memory
~ 60 GB Raid 10 Storage
~ 3 TB Monthly Traffic
~ 1 IPv4 included
Starting $24.99/mo.

*VPS Premium
~ 4096 MB Memory
~ 120 GB Raid 10 Storage
~ 4 TB Monthly Traffic
~ 1 IPv4 included
~ Starting $44.99/mo.

*VPS Elite
~ 8192 MB Memory
~ 180 GB Raid 10 Storage
~ 8 TB Monthly Traffic
~ 1 IPv4 included
Starting $84.99/mo.

Order now: https://hostpoco.com/cheap-us-vps-hosting.php

Follow us on Twitter: https://twitter.com/HostPoco
Find us on Facebook: https://www.facebook.com/HostPoco/