With quicker, modern, accessible apps allowing humans to practice meditation, mindfulness, & furthermore, a pathway to happiness, curiosity sprouts the question:
“Could the SPL database behave synonymously with the possible checkout decrease in mindful-meditation related items?”
Noticing the surprising range of the deweyClasses, I decided to pivot the focus of this visualization, in conjunction of my first focus, to see the checkout behavior over the years of what deweyClasses are the most popular.
FIRST QUERY: for overall checkout items + deweyClasses
Code: Select all
SELECT YEAR(cout) AS year, bibNumber, title, COUNT(bibNumber) AS Counts, deweyClass FROM spl_2016.outraw WHERE title LIKE '%meditation%' OR title LIKE '%happiness%' OR title LIKE '%mindfulness%' AND deweyClass > 0 AND deweyClass < 1000 GROUP BY YEAR(cout), bibNumber, title, deweyClass ORDER BY YEAR(cout), bibNumber, title, deweyClass
SECOND QUERY: to organize yearly dewey meditation items, created multiple annual csv files in order to quantify ranges of Deweys
Code: Select all
SELECT YEAR(cout), SUBSTRING(deweyClass, 1, 3), bibNumber, title, COUNT(bibNumber) AS Counts, deweyClass FROM spl_2016.outraw WHERE YEAR(cout) = 2008 //or any year AND (title LIKE '%meditation%' OR title LIKE '%mindfulness%') AND (SUBSTRING(deweyClass, 1, 3) BETWEEN 1 AND 1000) GROUP BY SUBSTRING(deweyClass, 1, 3) ASC, YEAR(cout) , bibNumber , title , deweyClass ORDER BY SUBSTRING(deweyClass, 1, 3) ASC, YEAR(cout) , bibNumber , title , deweyClass
DeweyClasses 100 (comp sci, info + general works), 200 (philosophy+psychology), 600 (technology) and 700 (arts + recreation) were the most popular nonfiction genres of all the deweyClasses. As much as they weren't a surprise overall, the lower checkout deweyClasses struck the most surprises, including social sciences (400) and history/geography(900). Looking deeper into the entries (as demonstrated in the progress presentation slides I have), several many interesting book titles were embedded in these minor checkout rate deweyClasses.
Overall, it can be observed that even though our digital technology has fluctuated over time, especially in its features, books related to mindfulness and meditation has always remained consistent in its checkout numbers, especially within the deweyClasses as well.