#!/bin/bash
a=`cat query1.txt | awk '{print $2 "-" $5}'| grep CLERK | wc -l`
echo Clerk $a
b=`cat query1.txt | awk '{print $2 "-" $5}'| grep SALESPERSON | wc -l`
echo Salesperson $b
c=`cat query1.txt | awk '{print $2 "-" $5}'| grep MANAGER | wc -l`
echo Manager $c
d=`cat query1.txt | awk '{print $2 "-" $5}'| grep STAFF | wc -l`
echo Staff $d
e=`cat query1.txt | awk '{print $2 "-" $5}'| grep ANALYST | wc -l`
echo Analyst $e
f=`cat query1.txt | awk '{print $2 "-" $5}'| grep PRESIDENT | wc -l`
echo President $f
Получится вот что
Clerk 7
Salesperson 10
Manager 7
Staff 2
Analyst 4
President 1
Но я плохо знаю bash дождитесь других советов