Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET SESSION SQL_MODE='';
- SELECT city, year, sum(revenue)
- FROM yearly_revenues
- GROUP BY city, year WITH ROLLUP;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement