Extracting Data

You have been tasked with extracting the name and email address of all users with a valid ExpenseCode value (100, 200, or 300). The email addresses are stored in the contacts table within the demo database. The expense codes are stored in ‘/tmp/demo.csv’.

To extract only the valid names and email addresses, you will first need to convert the CSV file to a PostgreSQL database table, by creating a new table and loading the data from the CSV file.

Next, you will need to query the data by joining the newly created users table with the contacts table on the ID column, and selecting only the rows with a valid expense code.

Lastly, you must export the valid names and email addresses to a new CSV file.