If I were doing this exercise on Windows, I might well use the visual SQL query builder and SQL command line in Alpha Anywhere. Connect to a PostgreSQL database ...

This is likely because when I first learned it was with command-line tools, but even so, I think command-line database tools often are the best way to interact with a database manually. Two of the ...