PART $1$ Creating the Table and Importing the Data

$1.$ Create the table with appropriate data types

a$.$ Name the table customer$\_$spending

b$.$ Reuse the column titles from the csv$,$ do not change these

c$.$ When selecting data types for your tables, ensure they accommodate the full

range of values and avoid truncating any values. Ensure that decimals, lengths,

and other specifications are sufficient for all data to be imported completely.

i$.$ You must declare precision and scale when applicable.

ii$.$ Go bigger if needed$-$ you will not lose points for adding extra space but

you will lose points if your data types do not accommodate all values.

iii. Do not use double precision as a data type in this assignment.

$2.$ Write the copy statement to bring the data into the database

a$.$ Remember that if you choose an incompatible data type, you can enter the

command DROP TABLE customer$\_$spending to remove the table and restart.

$3.$ Run a basic select statement that verifies the data is present and matches what is in the

csv file.

Make sure to include the table creation and copy statement in your code as this is a

component of your grade as demonstrated in the rubric below.