LAB 4: awk EXERCISE

LAB 4: awk EXERCISE

(Refer to the database called lab4.data on the CD.)

Mike Harrington:[phone]:250:100:175

Christian Dobbins:[phone]:155:90:201

Susan Dalsass:[phone]:250:60:50

Archie McNichol:[phone]:250:100:175

Jody Savage:[phone]:15:188:150

Guy Quigley:[phone]:250:100:175

Dan Savage:[phone]:450:300:275

Nancy McNeil:[phone]:250:80:75

John Goldenrod:[phone]:250:100:175

Chet Main:[phone]:50:95:135

Tom Savage:[phone]:250:168:200

Elizabeth Stachelin:[phone]:175:75:300

The database contains the names , phone numbers , and money contributions to the party campaign for the past three months.

1. Print the first and last names of those who contributed more than $100 in the second month.

2. Print the names and phone numbers of those who contributed less than $85 in the last month.

3. Print the names of those who contributed between $75 and $150 in the first month.

4. Print the names of those who contributed less than $800 over the three-month period.

5. Print the names and addresses of those with an average monthly contribution greater than $200 .

6. Print the first name of those not in the 916 area code.

7. Print each record preceded by the number of the record.

8. Print the name and total contribution of each person.

9. Add $10 to Chet 's second contribution.

10. Change Nancy McNeil 's name to Louise McInnes .