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
I used Processing.

Run in Browser

Source Code