title: SQL Access with Table
body: <p>It wont let me upload image but columns are OrderID, CustomerName, CustomerAddress, ProductNumber, SellDate, ProductDescription</p>
  
  <p>I am trying to teach myself SQL. Could someone please help me identify a few things?</p>
  
  <p>1) I want to write a SQL statement that retrieves the customer name and address of the customer that placed order 7.</p>
  
  <p>Is this right?</p>
  
  <pre><code>Select CustomerName, Address
  From Order 
  Where OrderID = ‘7’
  </code></pre>
  
  <p>2)Next I want to write an SQL statement that adds a new order to the Order table.</p>
  
  <p>Is this right?</p>
  
  <pre><code>INSERT INTO order(OrderID, CustomerName, CustomerAddress, ProductNumber, SellDate, ProductDescription) 
  VALUES (8, 'Ben C', '12 Kents Road', 01/15/2012, Clay :)); 
  </code></pre>
  
  <p>3) What is wrong with this data model and how would you redesign it? I really need help here. Does it need to be sorted? How could I describe a new high level design?</p>
  
  <p>4) How would I move this data from an old model to a new model?</p>
  
  <p>5)Using the new data model, I need to write a JOIN that retrieves the customer name and address of the customer that placed order 7. I have not gotten here yet because I am not sure why the old data model is bad.</p>