title: SQL statements practicing statements answer verification?
body: <p>Lets say I have  4  tables </p>
  
  <blockquote>
    <p>Region (RegionCode, RegionName)</p>
    
    <p>Customer (CustCode, CustName, CustAdress, CustBalance, RegionCode)</p>
    
    <p>EmployeeType (EmployeeType, HourlyPayRate,)</p>
    
    <p>Employee (EmployeeNo, EmployeeName, EmployeeAddress, RegionCode,
    EmployeeType)</p>
  </blockquote>
  
  <p>My goal is to </p>
  
  <blockquote>
    <p>List the Employee numbers, names and address of all the employees
    working in the Region whose code is MUN and the name is John Smith.</p>
  </blockquote>
  
  <p>My answer is as follows</p>
  
  <pre><code>SELECT EmployeeNo, EmploeeName, EmployeeAddress
  FROM Employee
  WHERE RegionCode = 'MUN' AND EmployeeName = 'John Smith';
  </code></pre>
  
  <p>I am tempted to join tables here, but am I right in saying as I can extract all information from this single table <code>Employee</code> I do not have to?</p>