Known old boy It education a week of the financial admissions expense report is as follows:
Student students to raise the fees paid for the course Consultant
1 Ge Yi 1500 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > 13100 0 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > crooked
2 Roggia 1500 13000 0 Danny
3 Wu Shing 500 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > 15000 0 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > crooked
4 臧阔 500 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > 3200 0 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > rain God
5 Chen Ji 500 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > 7500 0 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > crooked
6 Zhu Ming 500 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > 15000 0 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > rain God
7 railing 100 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > 3000 0 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > Danny
8 Chen Enlin 100 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > 5300 0 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > crooked
9 Zhang Linkun 300 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > 3200 0 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > rain God
10 Liang Yu 80 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > 2500 0 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > snow God
11 Luo Shuai 50 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > 500 0 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > rain God
12 Zhang San 80 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > 12200 0 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > snow God
13 John Doe 80 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > 2100 0 Span class= "Apple-tab-span" style= "White-space:pre;background-color:rgb (216,216,216);" > Thor
Harry23000 Thor
Tip: This data is sample data, not real data!
Please use shell scripts to help the old boy. It education finance do the cost statistics:
1, the request according to the total cost of each consultant enrollment from high to low sorting, print out the course consultant name, QQ number, the number of students enrolled in each consultant, the sum of the total cost of each consultant admission sum. No less than 2 ways to implement, the processing of the field name removed!!
!
Hint: The answer is similar to the following: The process or test you first, exercise it.
650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/75/FE/wKioL1ZHKI_xrp6nAABpA5H18_w297.jpg "title=" Snap11.jpg "alt=" Wkiol1zhki_xrp6naabpa5h18_w297.jpg "/>
What, no? You can refer to the following course and have the same questions in detail.
easily master the awk array Enterprise problem case deep combat video Course
Http://edu.51cto.com/course/course_id-4319.html
The students and netizens to make comments to the answer, finance teacher online waiting for use.
This article is from the "Old boy Linux ops" blog, please be sure to keep this source http://oldboy.blog.51cto.com/2561410/1712768
Use Shell to solve real-world enterprise problem case practice