sql command line

timer Asked: Jan 26th, 2016

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) Studypool Tutor
School: University of Maryland
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags

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