sql command line

  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.