Ripping through the book for review and noticed that some of the tables that are used as examples do not exist in my Adventureworks2012. Odd since the last update I see on MS code plex is for March 2012 and I downloaded the database in 2013.
for example from chapter 3 I do not have HumanResources.Employee2 table. so scripts such as :
SELECT ManagerID, COUNT(*)
GROUP BY ManagerID;
Did I skip something at the beginning of the book? am I supposed to download an update script?