SELECT name, continent, indep_year, CASE WHEN indep_year < 1900 THEN 'before 1900' WHEN indep_year <= 1930 THEN 'between 1900 and 1930' ELSE 'after 1930' END AS indep_year_group FROM countries ORDER BY indep_year_group;
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter