Write a WITH statement to include with COPY to handle the import of an

imaginary text file whose first couple of rows look like this:

id:movie:actor

$50$:#Mission: Impossible#:Tom Cruise

$2.$ Using the table us$\_$counties$\_$pop$\_$est$\_2019$ you created and filled in this

chapter, export to a CSV file the $20$ counties in the United States that had

the most births. Make sure you export only each county$$s name, state, and

number of births. $($Hint: births are totaled for each county in the column

births$\_2019.)$

$3.$ Imagine you$$re importing a file that contains a column with these values:

$17519\mathrm{.}668$

$20084\mathrm{.}461$

$18976\mathrm{.}335$

Will a column in your target table with data type numeric$(3,8)$ work for

these values? Why or why not?