Create a Postgres database.

This database will be used throughout the rest of the exercise.

Create a Python script that initializes the database with an empty table.  

The table should have the following columns:
- “Transaction-ID”: unique identifier
- “Created at”: date when the invoice was issued
- “Start Date”: start date of the period covered by the invoice
- “End Date”: end date of the period covered by the invoice
- “Amount USD”: total amount of the invoice
- “Status”: can be “issuable”, “issued”, “paid”, “not_invoiced”, “overdue”, “voided”
- “Revenue Type”: can be Subscription plan (SPC), Subscription plan Extra (SPE), One-time services (OTS), Top-up (TOP), Refunds (REF), Trial (TRI), Discounts (DIS)

In this repo you can find a .CSV with the contents that should be used populate the database.

Create a Python script that loads the data from CSV and populates the database.

The data you populated the database with is actually the revenue of Company X. 

Please write an SQL query that determines and shows the daily revenue of company X according to the following rules:

1. Calculate the daily revenue for 2017 (i.e. split the invoices in the corresponding days covered by the invoice);
2. When there is no “start-date” or “end-date”, please consider the “created date” (for both cases);
3. Status not to be considered as Revenue: “voided” and “overdue”. All others can be considered as revenue.