Help me in solving SQW42 problem

My issue

Not able to solve the problem

My code

/* Write a query to do the following
- We need to output the following - 'connection_id', 'origin', 'destination', 'truck_type' and 'running_cost'.  
- Cost of operating a truck is the alias - running_cost = distance x cost_per_distance. 
- **Hint** you will need to JOIN the tables 'Network' and 'Truck' and then apply relevant conditions */



Learning course: Learn Data Analytics using SQL and Python
Problem Link: Practice Problem in - CodeChef