question answer

Northeastern University, ITC 2811 – Advanced Application Development Assignment 6

Page 1 of 1

Assignment 6

For this assignment, you are going to answer the following questions using the Structured Query

Language (SQL) language. Please do not include any screenshots or results- just list the queries.

1. Using the CREATE TABLE statement, create a table called City with the following columns:

Column Name Data Type Accepts NULL

ID INT (Primary Key) No

Name VARCHAR(50) No

Region VARCHAR(50) Yes

Population INT Yes

Year_Established INT Yes

2. Write a query to select all unique Region values in the City table.

3. Write a query to select the Name values for all records where their Region is equal to

Northeast.

4. Write a query that returns all records where their region is equal to Midwest or have a

Population of less than 1,000,000.

5. Write a query that returns all records that have a Population of more than 50,000 and

whose Year_Established is NOT NULL.

What to Submit

To submit this assignment, save your answers in a Word document (or any other rich word

processing program that allows you to create .doc documents), save it as Assignment6FN (where

F is your first initial and L is your last initial), and submit them to me via the Blackboard.

Good luck and don’t hesitate to contact me if you have any question