PostgreSQL：在同一查询中使用计算列

I am having trouble using a calculated column in postgres. A similar code which works in SQL is given below, is it possible to recreate this in I am having trouble using a calculated column i