Media Arts and Technology

Here's a rough Processing sketch that shows some of the most interesting check-in anomalies.

-- karl

here's a query makes a sorted list of each deweyclass, counts the total number of checkout transactions for each deweyclass and makes a list of all the barcodes of the items that belong to each deweyclass. select deweyclass as deweyClass, count(*) as numberOfCheckouts, group_concat(distinct i.barcod...

select deweyclass,count(*) c from transactions t,items i where t.barcode = i.barcode and deweyclass like '70%' group by deweyclass order by c desc;

count the number of times each deweyclass that starts with '70' has been checked out.

select itemtype,count(*) c from items i group by itemtype order by c desc;

count the number of items for each itemtype and sort in descending order.

select t.barcode,count(*) from items i,transactions t where t.barcode = i.barcode group by t.barcode limit 100; this gets all the barcodes with a count of the number of times they've been checked out. select deweyclass,itemtype,ckoutDateTime,ckinDateTime from items i, transactions t where i.barcode ...