Task $1(40$ points$)$

Generate a report containing the lowest, highest and average score for each assignment in the data file. The name of the assignment is located in column $3.$ Your report should be in a tabular format as shown in the sample below;

Name Low High Average

Q$06779586\mathrm{.}80$

L$05409646\mathrm{.}60$

WS $555$

Q$075810078\mathrm{.}80$

L$06609961$

L$07778664\mathrm{.}80$

H$01199047\mathrm{.}80$

H$02479574\mathrm{.}60$

H$03709582\mathrm{.}20$

H$04468065$

H$05549576\mathrm{.}60$

H$06589780\mathrm{.}60$

Q$012510074\mathrm{.}80$

H$07529067$

Q$028410091\mathrm{.}60$

L$01419175$

Q$033310066\mathrm{.}80$

L$02010061\mathrm{.}40$

Q$045510081$

L$038810095\mathrm{.}80$

FINAL $589985\mathrm{.}60$

Q$05549976\mathrm{.}80$

L$044810079\mathrm{.}20$

Your solution must generate the report using the data file given $($Lab$03-$data.csv Download Lab$03-$data.csv$).$ No points will be awarded for solutions that copy$-$paste the above sample data and use awk to print it to the console. Provide the command used to run your script against the lab$03$ data file along with your completed awk script.