上面这个数据库的记录内容包括姓名、电话号码和最近3个月的竞选捐款数额。

.打印在第二个月捐款超过100美元的人的姓和名。

awk -F: '$4>100{print $1}' lab3.data

.打印在最后一个月捐款少于85美元的人的姓名和电话号码

awk -F: '$5<85{print $1,$2}' lab3.data

.打印第一个月捐款额在75~150美元之间的人。

awk -F: '$5>=75 && $5<=150 {print $1}' lab3.data

.打印这3个月的捐款总额不超过800美元的人。

awk -F: '$3+$4+$5 <= 800 {print $1}' lab3.data

.打印月均捐款额大于200美元的人的姓名和电话号码。

awk -F: '$3+$4+$5 > 600{print $1,$2}' lab3.data

.打印不在916区的人的姓。

awk -F"[ :]" '$3 !~ "916"{print $2}' lab3.data

.打印每条记录，并在记录前加上其记录号。

awk '{print NR,$0}' lab3.data

.打印每个人的姓名和捐款总额。

awk -F: '{print $1,$3+$4+$5}' lab3.data

.把Chet第二个月的捐款额加上10

awk -F: '/Chet/{$4=$4+10} {print $0}' lab3.data

.把 Nancy McNeil的名字改成Louise McInnes

awk -F: '/Nancy McNeil/{$1="Louise Mclnnes"} {print}' lab3.data

                       ***CAMPAIGN  CONTRIBUTIONS***

--------------------------------------------------------------------------------

NAME                      PHONE            Jan  |  Feb  |  Mar  |  Total Donated

--------------------------------------------------------------------------------

Mike Harrington     () -        250.00  100.00  175.00  525.00

Christian Dobbins   () -        155.00  90.00   201.00  446.00

Susan Dalsass       () -        250.00  60.00   50.00   360.00

Archie McNichol     () -        250.00  100.00  175.00  525.00

Jody Savage         () -        15.00   188.00  150.00  353.00

Guy Quigley         () -        250.00  100.00  175.00  525.00

Dan Savage          () -        450.00  300.00  275.00  1025.00

Nancy McNeil        () -        250.00  80.00   75.00   405.00

John Goldenrod      () -        250.00  100.00  175.00  525.00

Chet Main           () -        50.00   95.00   135.00  280.00

Tom Savage          () -        250.00  168.00  200.00  618.00

Elizabeth Stachelin () -        175.00  75.00   300.00  550.00

--------------------------------------------------------------------------------

                              SUMMARY

--------------------------------------------------------------------------------

The campaign received a total of $6137.00 for this quarter.

The average donation for the  conrtibutors was $511.42.

The highest contribution was $450.00.

The lowest contribution was $15.00.

$ cat lab3.awk

#!/usr/bin/awk -f

BEGIN{

    FS=":"

    print "                       ***CAMPAIGN 1998 CONTRIBUTIONS***"

    print "--------------------------------------------------------------------------------"

    print "NAME                      PHONE            Jan  |  Feb  |  Mar  |  Total Donated"

    print "--------------------------------------------------------------------------------"

    min=1000.0

    max=

    total=

}

{

    total+=$+$+$

    if($<min)

        min=$

    if($<min)

        min=$

    if($<min)

        min=$

    if($>max)

        max=$

    if($>max)

        max=$

    if($>max)

        max=$

    printf "%-20s%14s        %-6.2f  %-6.2f  %-6.2f  %-6.2f\n",$,$,$,$,$,$+$+$

}

END{

    print "--------------------------------------------------------------------------------"

    print "                              SUMMARY                                           "

    print "--------------------------------------------------------------------------------"

    printf "The campaign received a total of $%6.2f for this quarter.\n",total

    printf "The average donation for the 12 conrtibutors was $%5.2f.\n",total/12.0

    printf "The highest contribution was $%5.2f.\n",max

    printf "The lowest contribution was $%4.2f.\n",min

}