Joe Faulkner, whose faculty ID is 5000008, has asked that the max class size for just his ENG120 classes be decreased by 5. Before the change is implemented, the Academic Dean would like to see how this would have affected classes to which he has already been assigned. Write a query that returns the faculty ID, course ID, course title, the current max class size and the proposed new max class size of Joe’s composition classes. Make sure that the query only returns the requested information and includes a column alias for the calculated new max class size and table aliases.

Create a string list. 2. use console.readline() to collect values of firstname, lastname, street, city, state, zip, save them to list. 3. write a simple linq statement, call method uppercasewords() to change first letter to uppercase. 4. create a foreach statment to display the information. public static string uppercasewords(string value) { char[] array = value.tochararray(); if (array.length > = 1) { if (char.islower(array[0])) { array[0] = char.toupper(array[0]); } } for (int i = 1; i < array.length; i++) { if (array[i - 1] == ' ') { if (char.islower(array[i])) { array[i] = char.toupper(array[i]); } } } return new string(array);