Need some assistance with this.

#Write an awk script that will output the line numbers of each record that has less than or equal to 4 fields:

Input file:

1,3,5,8,10,11,54

1,2,3,4

15,18,21,42,37

1,1,1,0,0,3,16

4,1,8,0,4,6,13,16,17,20,8,6,4

13

Output expected:

2

6

#Write an awk script that will output the most popular dog breed based on number of votes using the information from the following entirely unbiased survey.

Input file:

Breed, Votes

Black Lab, 30

Chihuahua, 2

Pug, 1

Corgi, 45

Shar Pei, 21

Shih Tzu, 5

Maltese, 7

Output expected:

Corgi has 45 votes

#Write an awk script that will output the records that contain only letters.

Input file:

Avengers: Endgame

Star Wars: Episode 7 - The Force Awakens

The Great Gatsby

Furious 7

Avengers: Infinity War

Frozen 2

Harry Potter and the Deathly Hallows: Part 2

Lion King 1

The Fate of the Furious

Minions

Iron Man 3

Output expected:

Avengers: Endgame

The Great Gatsby

Avengers: Infinity War

The Fate of the Furious

Minions

#Write an awk script that will output the sum of all the sales figures.

Input file:

Name,Emp ID,Sales,Dept,Resi

Andrew,24,88,Eng,Y

Brandon,66,14,Mkt,Y

Chelsey,8,,Eng,N

Deborah,38,,Ift,Y

Erik,32,13,Mkt,N

Arielle,13,48,Eng,N

Shaun,55,78,Ift,N

Ninette,3,24,Opr,Y

Nguyen,10,54,Eng,Y

Output Expected:

SUM: 319

#Write an awk script that will output the average of all the sales figures.

Input file:

Name,Emp ID,Sales,Dept,Resi

Andrew,24,88,Eng,Y

Brandon,66,14,Mkt,Y

Chelsey,8,,Eng,N

Deborah,38,,Ift,Y

Erik,32,13,Mkt,N

Arielle,13,48,Eng,N

Shaun,55,78,Ift,N

Ninette,3,24,Opr,Y

Nguyen,10,54,Eng,Y

Output expected:

AVG: 35.4444

***expected execution: