I can't figure out how to correctly display the value from the table through select?

Question

PostgreSQL

I'm learning database and ran into a problem.
There is a table in my database:


I need to display something like this:


But I can't figure out how to bind my column "gender" so that in my display next to female and male names it would display he\she

Answer 1

select case when gender = 'm' then 'he' else 'she' end from ...