C Sharp Basic assignment
kool92
c_homework_nan.docxThe 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
