title: Tables not creating? Syntax issue?
body: <p>I am currently doing a lab for school and cannot for the life of me figure out why I am getting these errors (2 in particular). The first error thrown to me is that in the table "invoice" the PRIMARY KEY constraint is asking for a second right parentheses. The second error I'm receiving is in the creation of table "invprod" where it is arguing to me that "invno" doesn't actually exist.</p>
  
  <p>I don't know if this is an error in my syntax or otherwise but any help is greatly appreciated.</p>
  
  <pre><code>CREATE TABLE invoice
  (invno CHAR(5) NOT NULL
  ,invdate DATE
  ,orderno CHAR(5) NOT NULL
  ,CONSTRAINT invorder FOREIGN KEY (orderno)
            REFERENCES salesorder(orderno)
  ,CONSRAINT pkinvoice PRIMARY KEY (invno)
  );
  
  CREATE TABLE invprod
  (invno CHAR(5) NOT NULL
  ,partno CHAR(4) NOT NULL
  ,shipqty INTEGER CHECK (shipqty&gt;0)
  ,CONSTRAINT fk1invprod FOREIGN KEY(invno)
          REFERENCES invoice(invno)
  ,CONSTRAINT fk2invprod FOREIGN KEY(partno)
          REFERENCES part(partno)
  );
  </code></pre>