The data for 10 Professional Baseball teams for the year 2001 is given below. Write a C# Console Application that does the following:
1) Create a Class called Team that can be used to represent this data
2) Create a List Collection of Teams with the data given
3) Write LINQ queries to that output the following:
(a) List of teams sorted by number of Wins- ascending (List all columns)
(b) List of teams sorted by number of Runs Scored - ascending(List all columns)
(c) List teams sorted by E.R.A - ascending (List only Team names and ERA)
(d) Create a LINQ calculated Column called 'Runs Per Win' (= Runs Scored / Wins). List of teams that have 'Runs Per Win' of 9 or more
Team Wins E.R.A. Runs Scored
---------- ----- ------ -----------
Anaheim 75 4.20 691
Baltimore 63 4.67 687
Boston 82 4.15 772
Chicago White Sox 83 4.55 798
Cleveland 91 4.64 897
Detroit 66 5.01 724
Kansas City 65 4.87 729
Minnesota 85 4.51 771
New York Yankees 95 4.02 804
Oakland 102 3.59 884