Unconventional Yet Common Aggregation Operations
Standard SQL provides five fundamental aggregation operations: SUM, COUNT, AVG, MIN, and MAX—all compute a single value from a set.For example, finding the first login time for user 1001 in a log ta...