title: Attempting to list employee name and ID for employees working on a property in Seattle
body: <p>I'm supposed to use a subquery, but I'm not quite certain where I'm going with this.
  I know that I need to match EmployeeIDs from the ggemployee table and the property_service table, then match the PropertyID from the property_service and owned_property tables, then make sure that the PropertyID is tied with the property in Seattle.</p>
  <p>I'm just a bit lost with where I need to go from here.</p>
  <p>This is the code I have now:</p>
  <pre><code>select ggemployee.LastName, ggemployee.FirstName, ggemployee.EmployeeID
  from ggemployee
  inner join property_service on property_service.EmployeeID = ggemployee.EmployeeID
  inner join owned_property on property_service.PropertyID = owned_property.PropertyID
      and owned_property.PropertyName = 'Seattle';
  </code></pre>
  <p>I attempted to do this with join on syntax, but haven't quite got it working. If someone could show me the proper way to do this with <em>join on</em> and <em>subqueries</em> that would be absolutely amazing.</p>
  <p>Thank you so much in advance for the help!</p>
  <p>EDIT:
  I also tried something like this..</p>
  <pre><code>select ggemployee.LastName, ggemployee.FirstName, ggemployee.EmployeeID
  from ggemployee, property_service, owned_property
  where property_service.EmployeeID = ggemployee.EmployeeID
      and property_service.PropertyID = owned_property.PropertyID
      and owned_property.PropertyName = 'Seattle';
  </code></pre>
  <p>EDIT2: I am dumb, PropertyName is supposed to be city. Sorry!</p>