awk for administrators: fields, conditions, sums, reports

Objective

Use awk for what it does better than any other command-line tool: reading columns, filtering on a condition, calculating (sums, averages, maximum) and grouping by category. In one line, you will turn a file or the output of a command into a small report with figures.