PRACTICELABFIVE.docx - Write Ten SQL SELECT statements to...

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

We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Systems Analysis and Design in a Changing World
The document you are viewing contains questions related to this textbook.
Chapter 4 / Exercise 27
Systems Analysis and Design in a Changing World
Jackson/Satzinger
Expert Verified
Write Ten SQL SELECT statements to query the STUDENT schema you created for practice lab 1. Your Select Statements should run error- free and should be valid. Submit two separate files: one plain text file (.txt or .sql file) with your SELECT statements only; and the other document (doc/docx/pdf) include both your SELECT 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. 1. Show the number of instructors who have a zip of 10025 and a the street number of 518. 2. Display all students who live in the state of MA. List first name, last name, zip, and city. Sort by city (descending), zip (ascending), and last name (ascending). 3. List all zipcodes where at least three students AND at least four instructors reside. Show zip, state and city. 4. List all cities that have 10 or more students and instructors combined. Show city, state, number of student residents, number of
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Systems Analysis and Design in a Changing World
The document you are viewing contains questions related to this textbook.
Chapter 4 / Exercise 27
Systems Analysis and Design in a Changing World
Jackson/Satzinger
Expert Verified

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture