Advertisement
Guest User

Untitled

a guest
Jun 27th, 2019
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. SELECT date, price/rate AS adjusted FROM
  2. table1 a JOIN table2 b ON a.date=b.date
  3.  
  4. date price
  5. 2019-01-01 2.3
  6. 2019-01-03 3.4
  7. 2019-01-04 2.6
  8. 2019-01-05 2.2
  9. 2019-01-06 2.5
  10. 2019-01-07 5.1
  11. 2019-01-08 4.6
  12. 2019-01-09 4.2
  13. 2019-01-10 3.3
  14.  
  15. date rate
  16. 2019-01-04 1.1
  17. 2019-01-06 1.3
  18. 2019-01-09 1.0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement