如何在Postgres中使用别名创建嵌套的SELECT COUNT

i'm writing the following SQL query for my Postgres database:i'm writing the following SQL query for my Post