Hello, I am taking an Introductory to Unix/Linux course and I have an assignment in which I have to create a script that will print the number of wines by type from a txt file. The only problem I really have is understanding how to create another file using awk or sort to separate the wine types.

The file below this drop, wine.txt, contains the records from a wine data file. The 5 fields in each row are: The wine identification number Wine name Type of wine (2-Sparkling, 3-Fortified, 4-Sweet, 5-White, 6-Red) Year wine was made Winery Number This assignment requires that you create a report that will print the number of wines by type. The report should have a proper heading that includes a main heading e The main heading should include the current date The report heading should also have column headings for the type of wine and total (for the total of each type of wine) The record output should be formatted to display the data (wine type and count) below each column header The report should print on a "clean screen