LANGUAGE

CS140U

Write an awk script called labscript1.awk that will print out units sold and total revenue for goods sold in Europe. Remember to filter out the header. NOTE: You can use printf here to put tabs in and space out the printing but I'll take output from print as well (do put a space between at least) Below is example output:

L L 1 Region Country Item Type Sales Chan Order Prio Order Date Order ID Ship Date Units Sold Unit Price Unit Cost Total Reve Total Cost Total Profit 2 Australia a Tuvalu Baby Food Offline H ######## 6.69E+08 ######## 9925 255.28 159.42 2533654 1582244 951410.5 3 Central An Grenada Cereal Online ######## 9.64E+08 ######## 2804 205.7 117.11 576782.8 328376.4 248406.4 4 Europe Russia Office Sup Offline 5/2/2014 3.41E+08 5/8/2014 1779 651.21 524.96 1158503 933903.8 224598.8 5 Sub-Sahar: Sao Tome Fruits Online ######## 5.14E+08 7/5/2014 8102 9.33 6.92 75591.66 56065.84 19525.82 6 Sub-Sahar: Rwanda Office Sup Offline 2/1/2013 1.15E+08 2/6/2013 5062 651.21 524.96 3296425 2657348 639077.5 7 Australia a Solomon I: Baby Food Online 2/4/2015 5.48E+08 ######## 2974 255.28 159.42 759202.7 474115.1 285087.6 8 Sub-Sahari Angola Household Offline M ######## 1.35E+08 ######## 4187 668.27 502.54 2798046 2104135 693911.5 9 Sub-Sahar: Burkina Fa Vegetable: Online . ######## 8.72E+08 ######## 8082 154.06 90.93 1245113 734896.3 510216.7 10 Sub-Sahari Republic o Personal C Offline M ######## 7.7E+08 ######## 6070 81.73 56.67 496101.1 343986.9 152114.2 71 Sub-Sahari Senegal Cereal Online . ######## 6.17E+08 ######## 6593 205.7 117.11 1356180 772106.2 584073.9 12 Asia Kyrgyzstan Vegetable: Online H ######## 8.15E+08 ######## 124 154.06 90.93 19103.44 11275.32 7828.12 73 Sub-Sahar: Cape Verd Clothes Offline H 8/2/2014 9.4E+08 ######## 4168 109.28 35.84 455479 149381.1 306097.9 14 Asia Banglades Clothes Online ######## 1.87E+08 3/1/2017 8263 109.28 35.84 902980.6 296145.9 606834.7 15 Central An Honduras Household Offline H 2/8/2017 5.23E+08 ######## 8974 668.27 502.54 5997055 4509794 1487261 16 Asia Mongolia Personal C Offline C ######## 8.32E+08 ######## 4901 81.73 56.67 400558.7 277739.7 122819.1 17 Europe Bulgaria Clothes Online M ######## 9.72E+08 6/3/2012 1673 109.28 35.84 182825.4 59960.32 122865.1 18 Asia Sri Lanka Cosmetics Offline M ######## 4.19E+08 ######## 6952 437.2 263.33 3039414 1830670 1208744 19 Sub-Sahari Cameroon Beverages Offline C 4/1/2015 5.2E+08 ######## 5430 47.45 31.79 257653.5 172619.7 85033.8 20 Asia Turkmenis Household Offline ######## 4.42E+08 ######## 3830 668.27 502.54 2559474 1924728 634745.9 21 Australia a East Timor Meat Online ######## 3.22E+08 ######## 5908 421.89 364.69 2492526 2154589 337937.6 22 Europe Norway Baby Food Online ######## 8.19E+08 ######## 7450 255.28 159.42 1901836 1187679 714157 23 Europe Portugal Baby Food Online . ######## 8.61E+08 9/3/2015 1273 255.28 159.42 324971.4 202941.7 122029.8 24 Central An Honduras Snacks Online L ######## 7.95E+08 ######## 2225 152.58 97.44 339490.5 216804 122686.5 25 Australia a New Zeala Fruits Online H 9/8/2014 1.42E+08 ######## 2187 9.33 6.92 20404.71 15134.04 5270.67 ac L L razo L L 1 Region Country Item Type Sales Chan Order Prio Order Date Order ID Ship Date Units Sold Unit Price Unit Cost Total Reve Total Cost Total Profit 2 Australia a Tuvalu Baby Food Offline H ######## 6.69E+08 ######## 9925 255.28 159.42 2533654 1582244 951410.5 3 Central An Grenada Cereal Online ######## 9.64E+08 ######## 2804 205.7 117.11 576782.8 328376.4 248406.4 4 Europe Russia Office Sup Offline 5/2/2014 3.41E+08 5/8/2014 1779 651.21 524.96 1158503 933903.8 224598.8 5 Sub-Sahar: Sao Tome Fruits Online ######## 5.14E+08 7/5/2014 8102 9.33 6.92 75591.66 56065.84 19525.82 6 Sub-Sahar: Rwanda Office Sup Offline 2/1/2013 1.15E+08 2/6/2013 5062 651.21 524.96 3296425 2657348 639077.5 7 Australia a Solomon I: Baby Food Online 2/4/2015 5.48E+08 ######## 2974 255.28 159.42 759202.7 474115.1 285087.6 8 Sub-Sahari Angola Household Offline M ######## 1.35E+08 ######## 4187 668.27 502.54 2798046 2104135 693911.5 9 Sub-Sahar: Burkina Fa Vegetable: Online . ######## 8.72E+08 ######## 8082 154.06 90.93 1245113 734896.3 510216.7 10 Sub-Sahari Republic o Personal C Offline M ######## 7.7E+08 ######## 6070 81.73 56.67 496101.1 343986.9 152114.2 71 Sub-Sahari Senegal Cereal Online . ######## 6.17E+08 ######## 6593 205.7 117.11 1356180 772106.2 584073.9 12 Asia Kyrgyzstan Vegetable: Online H ######## 8.15E+08 ######## 124 154.06 90.93 19103.44 11275.32 7828.12 73 Sub-Sahar: Cape Verd Clothes Offline H 8/2/2014 9.4E+08 ######## 4168 109.28 35.84 455479 149381.1 306097.9 14 Asia Banglades Clothes Online ######## 1.87E+08 3/1/2017 8263 109.28 35.84 902980.6 296145.9 606834.7 15 Central An Honduras Household Offline H 2/8/2017 5.23E+08 ######## 8974 668.27 502.54 5997055 4509794 1487261 16 Asia Mongolia Personal C Offline C ######## 8.32E+08 ######## 4901 81.73 56.67 400558.7 277739.7 122819.1 17 Europe Bulgaria Clothes Online M ######## 9.72E+08 6/3/2012 1673 109.28 35.84 182825.4 59960.32 122865.1 18 Asia Sri Lanka Cosmetics Offline M ######## 4.19E+08 ######## 6952 437.2 263.33 3039414 1830670 1208744 19 Sub-Sahari Cameroon Beverages Offline C 4/1/2015 5.2E+08 ######## 5430 47.45 31.79 257653.5 172619.7 85033.8 20 Asia Turkmenis Household Offline ######## 4.42E+08 ######## 3830 668.27 502.54 2559474 1924728 634745.9 21 Australia a East Timor Meat Online ######## 3.22E+08 ######## 5908 421.89 364.69 2492526 2154589 337937.6 22 Europe Norway Baby Food Online ######## 8.19E+08 ######## 7450 255.28 159.42 1901836 1187679 714157 23 Europe Portugal Baby Food Online . ######## 8.61E+08 9/3/2015 1273 255.28 159.42 324971.4 202941.7 122029.8 24 Central An Honduras Snacks Online L ######## 7.95E+08 ######## 2225 152.58 97.44 339490.5 216804 122686.5 25 Australia a New Zeala Fruits Online H 9/8/2014 1.42E+08 ######## 2187 9.33 6.92 20404.71 15134.04 5270.67 ac L L razo