Not sure how to use psql

Hi all,

                I’m new to the sql language and recently learnt about psql, and have some questions about it. Firstly, after typing psql (mydatabase) in the shell, do I directly start coding? Next, when I create a table, must my headings be necessarily lowercased? Lastly, can someone help me figure out why I got this wrong?

 

Cravan