I need to compare the value of a coin vs the same coin from exactly three minutes ago. Yes 🙂
All data must meet all the values.

Is there...

My question;
Create a new column. In this column I would like to show the ratio of A.Price / B.Price when 3 minutes before(a.price) and current data(B.price) with same coin. 

Normally i want to Divide a.price/b.price with this code. Because I want to see the next change in 3 minutes.

Select a.tarih,a.coin,(A.price),b.tarih,b.coin,(B.price) from (SELECT tarih, coin, MIN(price ) AS...

What should I do if two or more rows contain the same values?

Normally my guess is that the code I wrote does not have to be the same?