Which sales person achieved the highest sales YTD? What is the projected yearly sales quota in 2011 for this person?
Sales people refer to PersonType = 'SP'; projected yearly sales refers to SalesQuota
SELECT T1.BusinessEntityID, SUM(T1.SalesQuota) FROM SalesPerson AS T1 INNER JOIN SalesPersonQuotaHistory AS T2 ON T1.BusinessEntityID = T2.BusinessEntityID WHERE STRFTIME('%Y', T2.QuotaDate) = '2011' GROUP BY T1.BusinessEntityID ORDER BY SUM(T1.SalesYTD) DESC LIMIT 1