and what does the cross apply query does ??

could you explain the code that starts from

SELECT c.Origin, c.Destination, c.Tonnage

,n=ROW_NUMBER() OVER (ORDER...

Actually when i run this on wamp server it shows following error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL...

I am really sorry but this one is definitely the final problem

here is the new defined problem(forget about the old one):

I m working on something called the analysis of...

Actually the data consist of tonnage from each and every origin to each and every destination .... For the return trip from Texas a tonnage value of 0 will be...

hey sorry forgot to mention this before

arizona alabama 788 is also there in original data

But lets say there is

arizona alabama 0 i.e tonnage value=0

data also...