select FLOOR(deweyClass/10)*10 subgroup, title, cout, cin from spl0.inraw where (deweyClass <> 'null' OR deweyClass <> NULL) and itemtype like '%bk' and (TIMESTAMPDIFF(HOUR, cout, cin)) > 0 and year(cout) >= 2009 and year(cin) <= 2011 and FLOOR(deweyClass/10)*10 in ('90','160','250','310','470','540','670','760','870','990');
760^|^Edward Hopper an intimate biography^|^2009-01-03 16:06:00.0^|^2009-01-03 17:16:00.0
670^|^Mill^|^2009-02-05 18:47:00.0^|^2009-03-23 11:23:00.0
90^|^Miniature books 4000 years of tiny treasures^|^2009-01-10 11:53:00.0^|^2009-04-03 11:22:00.0
540^|^invention of air a story of science faith revolution and the birth of America^|^2009-04-13 18:50:00.0^|^2009-05-02 15:44:00.0
