If I have a DB Table in Oracle with the following structure:
ID, location, transport, cost
Where transport = plane, train, automobile
how would i write a query to find the trips via automobile thatcost more than trips via train?
and a separate query to find the train trips that cost the exactsame price?
Expert Answer
An answer will be send to you shortly. . . . .