Top Answers

1. Is it wasteful to use ARRAY_AGG to get the first non-NULL value in a column?
   5 votes
2. 4 votes
3. Count events with a cool-down period after each instance
   3 votes
4. Build comma-separated list of qualifying column names
   3 votes
5. Query with small LIMIT gets slow with many hits
   3 votes