Linear Frequency
MAT 259, 2012
Anis Haron
Introduction
A simple single query visualization. Minimal design, and use of color to fully utilize available space.
Query
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;
Explanation
Returns all checkouts with "Catcher in the Rye" or "Holden Caulfield" in the title from 2005 to 2011, separated by year.
Result and
Analysis
Code