The following query will return the days when the British pound was at its lowest and highest against the dollar.
$ curl -XPOST --data \ " SELECT *,1/EUR,1/JPY,1/GBP,1/CHF FROM forex WHERE GBP = ( SELECT max(GBP) FROM forex) OR GBP = ( SELECT min(GBP) FROM forex) " \ -H 'content-type: application/text' \ https://sql.lspgn.workers.dev/ Date,EUR,JPY,GBP,CHF,1/EUR,1/JPY,1/GBP,1/CHF 2007-11-08,1.4666,0.008840265220012,2.10642728904847,0.883440756580929,0.681849174962498,113.118778126279,0.47473748806764,1.13193781535524