SQL

1. Create a new table in the database called DEPT_TEST.

It will have four columns: id, dept_name, dept_city, and dept_budget.

The ID is a fixed length number with 7 digits. It serves as the primary key.

Dept_name is a text field that will list the department name (e.g. accounting, finance, and so on).

Dept_city is the city where the department is located.

Dept_budget will include the budget for the department up to 2 decimal places (a typical department budget in this company would be around $10,000.

2. Populate the DEPT_TEST table with the following value:

ID	DEPT_NAME	DEPT_CITY	DEPT_BUDGET
1178999	accounting	chicago	5000

3. Populate the DEPT_TEST table with the following value:

ID	DEPT_NAME	DEPT_CITY	DEPT_BUDGET
1178900	finance	abilene	7000

4. Change the dept_name of ID 1178999 from accounting to HR.

5. Change the dept_city of dept_id 1178900 to new york.

6. Delete the dept_test table.