---

mkdir pk
cd pk

cat > file 
banana apple fruite
hook hot dog free
spam block mine
iphone pixel


touch temp{1..6} result

sed 's/ .*//' file > temp1
sed 's/^[^ ]* *//' file > temp2
sed '$d' temp1 > temp3
{ printf '\n'; cat temp3; } > temp4
sed '$d' temp2 > temp5
sed -n '$p' file >> temp5
paste -d ' ' temp4 temp5 > temp6
sed 's/^ //' temp6 > result
cat result

awk '{print $2, $3, $5}' query4

awk '$5=="SALESPERSON" && $6=="SALES" {
    print $4
    n++
}
END {
    print "Количество:", n
}' query1

awk '$5=="MANAGER" {
    if ($8>max) max=$8
}
END {
    print "Максимальная зарплата менеджеров:", max
}' query1


awk '{
    if (!($2 in max) || $5>max[$2]) {
        max[$2]=$5
        buyer[$2]=$3
    }
}
END {
    for (seller in max)
        print seller, buyer[seller], max[seller]
}' query4 | sort