Need sql command line code:1. Show the EDITORS’ first names in lower case and their last names in uppercase. Sort the result by name. 2. For the MORTALs, show last name, first name, the work phone number and a column that displays the phone number if there is one or displays null phone numbers as XXX-XXX-XXXX. This display has 4 columns. 3. Show only the AUTHORS’ names (no repeats). Use this format: last name comma space first initial period. 4. Show AUTHORS with their names in the following format (First name Last name) with all extra space to the right filled with dashes (-). This single column should be 30 characters wide with the dashes. 5. How many TEACHERs are high school teachers that have home room numbers? 6. List the school name and type. The name should be in upper case. Each word in the type column should be a capital letter with the remainder of the letters in each word in lower case. 7. Describe School. Write a SELECT statement that shows the length of the school name and the length of the type (2 columns). Explain the result.