Lab 6-2.docx - Sha-Tisma Williford DBST651 Lab 6 Write 10...

This preview shows page 1 - 2 out of 5 pages.

Sha-Tisma Williford DBST651 Lab# 6 Write 10 SQL statements against the STUDENT schema. Your statements should run error-free and should be valid. Submit two separate files: one plain text file (.txt or .sql file) with your statements only; and the other document (doc/docx/pdf) include both your statements and your query results (copy and paste text or screen shots). The instructor and TA should be able to run your plain text source file as script and generate the same output as shown in your result document. Q1. List all instructors. Show salutation in all lower cases, last name in all upper cases and phone number in the format of '(xxx) xxx-xxxx'. (HINT: use LOWER, UPPER and SUBSTR function) Q2. List all students (display student_id, first name, last name, street address, zipcode, city, and state) who live in New York, NY. Sort results by last name, and then first name, in descending order.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture