MAT 259, 2012
A simple single query visualization. Minimal design, and use of color to fully utilize available space.
select year(ckoutDateTime) as year,count(*) from trans_2005_thru_2011 where year(ckoutDateTime)>2004 AND (title like "%the catcher in the rye%" OR title like "%Holden Caulfield%") group by year order by year;
Returns all checkouts with "Catcher in the Rye" or "Holden Caulfield" in the title from 2005 to 2011, separated by year.