{eval=Array;=+count(Array);}
SELECT
p1,
p2,
min(startTime) AS startTime,
max(endTime) AS endTime,
SUM(count) AS count
FROM demo
GROUP BY p1,p2
0