with prep as (
SELECT * except (description, image_thumbnail)
FROM `properati-data-public.properties_ar.properties_sell_201511` where
price is not null and price != 0
),
average_usd as (
select
concat(extract(year from created_on),'-',extract(month from created_on)) as yearmonth
,round(avg(price),0) as avg_price
from prep
group by 1
order by 2 asc
),
popular_places as (
select place_name, count(distinct id) as number_of_flats from prep
group by 1
order by 2 desc
)
select * from average_usd