WITH amount_earned_table AS
(SELECT amount_earned
FROM daily_sales
INNER JOIN salesman
ON daily_sales.salesman_id = salesman.id
INNER JOIN city
ON salesman.city_id = city.id
GROUP BY city.name),

avgDailyAmt AS
(SELECT AVG(amount_earned)
FROM amount_earned_table)

SELECT city.id, city.name
FROM city
INNER JOIN avgDailyAmt
ON