Write a SELECT statement to list zipcodes and their cities in New York State sorted by zipcode. (123 rows)

What will be an ideal response?

```
SELECT zip, city
FROM zipcode
WHERE state = 'NY'
ORDER BY zip
```

Computer Science & Information Technology

You might also like to view...

The ____ function key will start a Visual Basic 2017 application in the IDE.

A. F2 B. F3 C. F4 D. F5

Computer Science & Information Technology

IBM developed ________ in the mid 1950s for scientific and engineering applications that require complex mathematical computations.

a) C b) Fortran c) COBOL d) Pascal

Computer Science & Information Technology