---

B12 Assignment Solutions

First problem

1. There are 2 separate SQL query blocks for MySQL and SQLite3 in the file named 'first_task.sql'.

Second problem

1. To run a script you need to have installed python (at least version 3.6) on your computer
2. Change direction to main directory with flight-optimizer file
3. Create new environment: python3 -m venv env
4. Activate new environment: source env/bin/activate
5. Install necessary python packages: pip install -r requirements.txt
6. To be able to run bash script in terminal you need to change permissions for a script file: chmod +x flight-optimizer
7. To get the best destination and price per kilometer in USD run command: ./flight-optimizer --from Stambul --to Madrid Lisbon Roma .