sql command line

Sigchi4life
Category:
Computer Science
Price: $10 USD

Question description

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.


Tutor Answer

(Top Tutor) Daniel C.
(997)
School: UIUC
PREMIUM TUTOR
Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1820 tutors are online

Related Computer Science questions

09/05/2013
09/04/2013

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors