Wrote query fetching the route_price for a given flight (using joins!).
Fixed some minor bugs.
Finished up the calculate_price procedure. The create reservation procedure still needs some work.