CASE Statements in PostgreSQL - DataCamp

PHOTO EMBED

Fri Apr 30 2021 16:46:08 GMT+0000 (Coordinated Universal Time)

Saved by @mvieira

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;
content_copyCOPY

https://www.datacamp.com/community/tutorials/case-statements-in-postgresql?utm_source