SET SESSION SQL_MODE='';

SELECT city, sum(revenue)
FROM yearly_revenues
GROUP BY city WITH ROLLUP;