Confused on how to find this answer in the tutorial?
Hi @Andrew Henry, after you run
SELECT year, max(runs) FROM batting GROUP BY year;
you can find output for specific year on the "Results" pad after scrolling down.
... 1911 248 1912 226 ...
However, only about 50 lines are shown, in my case up to 1919. You can also restrict the output to specific years using commands like:
SELECT year, max(runs) FROM batting where year=1912 GROUP BY year; year _c1 1912 226 SELECT year, max(runs) FROM batting where year>=1920 GROUP BY year; year _c1 1920 257 1921 237 1922 250 ...