mySQL Data Mining and Other Experiments Here

	A	B	C	D
1	Title	Avg number of months checked out	Number of checkouts	Total Available Items for Checkout

2	Ramadan	2.1835	278	46
3	Desire of the everlasting hills the world before and after Jesus	2.1118	170	12
4	Amazing grace a vocabulary of faith	2.4303	165	19
5	Egyptian gods and goddesses	2.0556	162	7
6	Egyptian mythology	2.0476	147	11
7	Killing the Buddha a heretics Bible	2.1389	144	8
8	Celebrate Diwali	2.0979	143	18
9	Jesus	2.5211	142	26
10	Covenant marriage building communication intimacy	2.0435	138	6
11	St Francis of Assisi a life of joy	2.2045	132	11
12	How we believe science skepticism and the search for God	3.0333	120	6
13	new Jewish wedding revised and updated	2.3833	120	8
14	knock at midnight inspiration from the great sermons of Reverend Martin Luther King Jr	2.125	120	24
15	case for faith a journalist investigates the toughest objections to Christianity	3.7059	119	9
16	Hanukkah	2.1261	119	31
17	Diwali Hindu festival of lights	3.7391	115	12
18	One world many religions the ways we worship	2.1652	115	11
19	first Rasta Leonard Howell and the rise of Rastafarianism	2.2411	112	6
20	Christianity	2.8165	109	31
21	Buddha in your backpack everyday Buddhism for teens	2.0377	106	9
22	Wide awake a Buddhist guide for teens	2.2	105	9
23	Muhammad a biography of the prophet	2.0095	105	5
24	Enchanted love the mystical power of intimate relationships	2.5631	103	4
25	golden fleece and the heroes who lived before Achilles	2.0194	103	9
26
27	Script
28	SELECT title, AVG(TIMESTAMPDIFF(MONTH, ckoutDateTime, ckinDateTime)) AS timeOut, count(barcode) AS checkouts, count(DISTINCT(barcode)) AS totalItems FROM transactionsall WHERE DATE_FORMAT(ckoutDateTime, '%Y') > '2004' AND deweyClass >= 200 AND deweyClass < 300 GROUP BY title HAVING AVG(TIMESTAMPDIFF(MONTH, ckoutDateTime, ckinDateTime)) > 2 AND count(barcode) > 100 ORDER BY checkouts DESC;
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100