create or replace view v_institutions as
select
	institutions.id,
    institutions.name,
    institutions.city_id,
    cities.name as city_name,
    institutions.status
from institutions
join cities on cities.id = institutions.city_id;
