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