Question: #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

#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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Linux Awk Files (There will be a second part posted as well) 1. Write an awk script file that will change all "/" characters to "+" in all lines. 2. Write an awk script file that will add one blank...

Q:

o write an awk script 'freesize.awk that gets the size of the free list after every "Free" or "Alloc" operation Your program should act like this: $. awk -f freesize . awk malloc-out.txt l wc -1 1000...

Q:

For this assignment, you will use awk only. Do not use bash, sed, perl, Python, or any other lan- guages/utilities not explicitly specified. News Commands Awk Script You have set up a news server and...

Q:

Lab D - AWK 100 lab points possible - 7 graded tasks (Rev. FA 2023) Introduction This lab assignment will assess what you have learned from the module's learning materials. Ensure that your distro is...

Q:

Please help with basic 'awk' programming You don't need advanced features of AWK for these scripts. Do not use 'getline' or 'next', and stick to basic AWK programming. Your awk programs will be run...

Q:

[AWK Programming] Please help me write this awk script using the three text files given below. Thank You! ----------------------------------------------------------------------- The three text files...

Q:

Please help with these three questions and make comments if possible so I can understand. 3. Awk . Your code for this and the next two question will be graded by a script so be sure that your scripts...

Q:

write an awk script freesize.awk that gets the size of the free list after every Free or Alloc operation. Your program should act like this: $ awk -f freesize.awk malloc-out.txt | wc -l 1000 $ awk -f...

Q:

Need help with an Awk Script, using only awk . We cannot use bash, sed, perl, python or any other language/ utilities I only need to code two scripts using Awk ( news.awk and newsfeed.awk ) News...

Q:

Linux Awk pt 2 5. Write an awk script file that will insert the contents of the /etc/passwd file between lines 14 and 15 of the input. 6. Write an awk script file that will sort lines 7 through 26 of...

Q:

Refer to E5.14. Determine the amount of the expected cash outflow assuming that taxes and bonus are paid in the budgeting period. Determine the net income expected.

Q:

Determine which of the following pairs of reactants will result in a spontaneous reaction at 25C. Fe3+(aq) +Al(s) Pb2+(aq) + Au(s) Na+(aq) + Cr(s) Ag+(aq) + Br(aq) None of the above pairs will react.

Q:

Which of the following statements are incorrect? Pieter held a Naspers share for 2 0 months. He purchased the share for R 1 2 0 1 . 0 0 and sold it after 2 0 months for R 1 6 8 6 . 0 3 . The...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

How do Dimensional Database Models differ from Relational Models?

Q:

What type of processing do Relational Databases support?

Q:

Describe several aggregation operators.