LAB6.docx - Instructions Write 10 SQL statements against...

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

We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
MIS
The document you are viewing contains questions related to this textbook.
Chapter 3 / Exercise 6
MIS
Bidgoli
Expert Verified
Instructions 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. Q3. Display the city in which each instructor lives. List first name, last name, zip,
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
MIS
The document you are viewing contains questions related to this textbook.
Chapter 3 / Exercise 6
MIS
Bidgoli
Expert Verified

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture