Although most systems have pandas built-in; to install pandas, do:
pip install pandas
Run normally
SQL code is not necessarily written to be run, or though compiler on PostgreSQL. The relationships are presented in task2.png
Unable to complete due to scheduling and time constraints, however willing to exchange further about related skills for the task
Python file can be run on vanilla Python, no further installation is needed. However, some assumptions on the input is required (example input provided in task4.py)
SQL code is compilable on PostgreSQL, there is a comment at the end of file demonstrating how adding a blog post would work.