
#   Exercise 2 Solution

   #--- Print table headings in BEGIN section, and init current year variable.

   BEGIN {  printf("Make   Total Value    Average Value    Average Age\n")
            printf("----   -----------    -------------    -----------\n")
   
	    current_year = 92
         }


   #--- For each manufacturer (make) get total value and total age

   /ford/    { fordtotval += $5   
               fordtotage += (current_year - $3)
	       fordcount++
             }
   /chevy/   { chevytotval += $5  
	       chevytotage += (current_year - $3)
	       chevycount++
	     }
   /plym/    { plymtotval += $5 
               plymtotage += (current_year - $3)
	       plymcount++
	     }
   /volvo/   { volvototval += $5 
	       volvototage += (current_year - $3)
	       volvocount++
	     }
   /fiat/    { fiattotval += $5
               fiattotage += (current_year - $3)
	       fiatcount++
             }
   /honda/   { hondatotval += $5
               hondatotage += (current_year - $3)
	       hondacount++
             }

        # printf("----   -----------    -------------    -----------\n")
   END {  printf("Ford   %7d            %5d              %2d\n", fordtotval, fordtotval/fordcount, fordtotage/fordcount )
          printf("Chevy  %7d            %5d              %2d\n", chevytotval, chevytotval/chevycount, chevytotage/chevycount )
          printf("Plym   %7d            %5d              %2d\n", plymtotval, plymtotval/plymcount, plymtotage/plymcount )
          printf("Volvo  %7d            %5d              %2d\n", volvototval, volvototval/volvocount, volvototage/volvocount )
          printf("Fiat   %7d            %5d              %2d\n", fiattotval, fiattotval/fiatcount, fiattotage/fiatcount )
          printf("Honda  %7d            %5d              %2d\n", hondatotval, hondatotval/hondacount, hondatotage/hondacount )
       }
