evan4/best_rates.sql

## best_rates.sql
select r.currency_code, round(min(r.sell),2) as sell,
    round(max(r.buy),2) as buy
    from rate_ru r
    where (r.date_json = CURDATE()) and r.exchanger_id <> r.exchanger_id in (select id
    from exchanger_ru e
    where (e.centralbank = 0 or e.centralbank is null))
    group by r.currency_code order by r.currency_code
	select r.currency_code, round(min(r.sell),2) as sell,
	round(max(r.buy),2) as buy
	from rate_ru r
	where (r.date_json = CURDATE()) and r.exchanger_id <> r.exchanger_id in (select id
	from exchanger_ru e
	where (e.centralbank = 0 or e.centralbank is null))
	group by r.currency_code order by r.currency_code