I am trying to learn SQL and I started with difficult SQL questions but this one is pretty difficult that I couldn’t figure it out.
A warehouse in Germany currently has two methods of retreving stock
from shelves. They have drones that can carry a relatively small
amount of weight. For larger items they use fork trucks, but fork
trucks are more expensive to operate and cannot travel directly from
point to point. In mathematical terms, Drones travel in euclidean
distance and fork trucks travel in manhattan distance.
Each method of transport has a cost per unit of distance per kg.
Additionally, each method of transport has a flat cost per trip. Cost
is calculated as:
w = item weight s = step cost d = distance t = trip cost cost = wsd +
The warehouse is considering investing in a teleportation system
(science fiction). The teleportation system’s optimal range is minimal
and thus they are set up in sequence with each item passing through a
series of nodes. These nodes are aligned in a grid pattern and a
single diagonal movement is considered the same as a horizontal or
vertical movement. Measuring distance in this system is called
Teleportation has a higher cost per unit of weight per unit of
distance to operate but can move more mass than a drone and less than
a fork truck. Unlike the drones and fork trucks, teleportation has no
additional flat cost per trip.
In order to decide whether to invest in teleportation technology, the
warehouse needs to generate various reports to compare technologies,
storage, transport cost, etc.
I need to display distances and costs as real numbers with two decimal places using “.” as the decimal market and display IDs and weights as integers. I am sorry for not being able to show any line of code. I couldn’t write anything for 20 minutes.
These are my given infos: