Glossary: Security Monitoring and Automation

GROUP BY

Also written: group by

The SQL clause that puts matching rows into groups and returns one result per group. brute.sql groups by address and `ts / 300` to count failures per address in each 5-minute block.