Due: Thursday, Jan 30, 2025

This assignment is worth 25 points. For full credit:

• submit responses to BrightSpace by class time on the due date
• see the Deliverables section below

Reading. Entering Queries

Resources. The Functions and Operators reference and Pattern Matching pages may come in handy.

Warmup Problems (4 points).

For questions 2 through 5, write an SQL query that computes the requested information. Provide screenshots of both the commands used and the result.

1. If you didn't change your password successfully in class, do it now. The screenshot should not show me your password!
2. Show the current time according to the database server.
3. Show the number of days since January 1st.
4. Show the current date in the form mm/dd/yyyy.
5. Compute the area of a circle whose radius is 10.

Basic SQL Queries (21 points - 3 points each).

Write an SQL query that computes the requested information. All such queries will come from the cities table in the cs284_spring25 database. Provide screenshots of both the commands used and the result.

6. Determine the number of cities in the table.
7. What is the 17th largest city in the table?
8. Show the 15 cities with the highest population, listed in name order alphabetically
9. Show the 15 cities with the smallest population, listed from largest to smallest population.
10. Which cities have a population between 500,000 and 1 million people?
11. Which cities have a name that contains exactly 6 characters?
12. How many cities in the table are in New Mexico?

Deliverables

• Include the Problem number in the filename of each screenshot.
• Create a zip file containing all screenshots for each problem and post to the Assignments page on BrightSpace.

---