If I were doing this exercise on Windows, I might well use the visual SQL query builder and SQL command line in Alpha Anywhere ... I wanted to use one of the PgFoundry Sample Databases, but ...

The command-line client is nice too ... or they can be broken up across many lines to make it easier to read. In the examples below, I do the latter. SQL statements usually end with a semicolon (;).