chatgpt's so good at building SQL query. you give their table structure description (u can copy paste it from pgAdmin), give some context, then chatgpt will help u with the sql query.