title: AdventureWorks2012:Identify the sales persons who have sales less than $100,000 since beginning of 2008. Show: Sales person login ID
body: <p>AdventureWorks2012: Identify the sales persons who have sales less than  $100,000 since beginning of 2008.
  Show: Sales person login ID.</p>
  
  <p>I guess the tables will be</p>
  
  <ul>
  <li><code>HumanResources.Employee</code></li>
  <li><code>Sales.SalesPerson</code></li>
  </ul>
  
  <p>Can someone plz help me. I have spent enough time </p>
  
  <pre><code>SELECT 
      E.LoginID 
  FROM 
      HumanResources.Employee AS E 
  JOIN 
      Sales.SalesPerson AS SP ON E.BusinessEntityID = SP.BusinessEntityID 
  WHERE 
      E.BusinessEntityID IN (SELECT BusinessEntityID 
                             FROM Sales.SalesPerson 
                             WHERE SalesQuota &lt; 100000); 
  </code></pre>