The Question
SQL
AWS Server Fleet Total Uptime
Given a log of server lifecycle events including start and stop timestamps for a fleet of instances, calculate the total cumulative uptime across all servers. The final result should be expressed as the total number of complete 24-hour days the entire fleet was operational.
Snowflake
CTE
Window Func
LEAD
DATEDIFF
March 4, 2026