drop view if exists realty_val;
create view realty_val as select (select max(date) from realty.indicator) as date, (select round(value,4) from realty.indicator where field=59 order by date desc limit 1) as usd, (select round(value,4) from realty.indicator where field=60 order by date desc limit 1) as eur;