Create Some SQL Queries (PostgreSQL)

I have a project where psql batch files need to be created for the following: 1. Drop Tables 2. Create Tables 3. Ingest data from .txt files (tab separated) to tables 4. Run 11 selection queries SQL variety is PostgreSQL, the level of complexity is on par with an introduction DB course. Data files and required queries will be provided on request prior to bidding to ensure the accepted freelancer is in agreement to the details of this project.