with daily_sums as (
select daily_sales.day,
city.id,
city.name,
sum(amount_earned)as sum_amount_earned
from daily_sales
join salesman on daily_sales.salesman_id = salesman.id
join city on salesman.city_id = city.id
group by daily_sales.day,city.id,city.name),

average_daily as
(select avg(sum_amount_earned) as avg_sum_amount_earned from daily_sums)

select daily_sums.id,
daily_sums.name,
count(daily_sums.day) from
daily_sums
where sum_amount_earned > (select avg_sum_amount_earned from average_daily)
group by daily_sums.id, daily_sums.name