$1.$ We created a csv file names my$\_$file.csv with the following information:

FIRSTNAME,LASTNAME,STREET,CITY,STATE,PHONE

John,Doe,$123$ Main st$.,$Hyde Park,NY$,845-555-1212$

$2.$ We ran this script:

create table city$\_$demo

copy city$\_$demo

FROM $\text{'}$C:$\backslash$Users$\backslash$Public$\backslash$scripts$\backslash$my$\_$file.csv$\text{'}$

WITH $($FORMAT CSV$,$ HEADER$)$;

$3.$ We received this error:

ERROR: extra data after last expected column

CONTEXT: COPY city$\_$demo, line $2$: "John, Doe, $123$Mainst, HydePark, NY$"$

SQL state: $22$P$04$

$----------------------------------------------$

What do you think went wrong??