Create a SELECT statement that would provide data for a faculty directory. Display should include faculty id, first name, middle initial, last name, office location (building and room), rank and phone number. The display should be sorted by last name descending order. Concatenate first name, middle initial and last name to look like ' James E. Smith'. Concatenate building and room to look like 'ENG102'. Override the column labels with meaningful descriptions.