Here's a rough Processing sketch that shows some of the most interesting check-in anomalies.
-- karl
Search found 6 matches
- Thu Mar 03, 2011 3:26 pm
- Forum: Winter 2011
- Topic: check-in anomalies
- Replies: 0
- Views: 51943
- Tue Feb 22, 2011 2:36 pm
- Forum: Winter 2011
- Topic: SQL queries on the vislab2 db
- Replies: 3
- Views: 6779
Re: SQL queries on the vislab2 db
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...
- Tue Feb 15, 2011 1:02 pm
- Forum: Winter 2011
- Topic: SQL queries on the vislab2 db
- Replies: 3
- Views: 6779
Re: SQL queries on the vislab2 db
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.
count the number of times each deweyclass that starts with '70' has been checked out.
- Tue Feb 15, 2011 12:36 pm
- Forum: Winter 2011
- Topic: SQL queries on the vislab2 db
- Replies: 3
- Views: 6779
Re: SQL queries on the vislab2 db
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.
count the number of items for each itemtype and sort in descending order.
- Tue Feb 15, 2011 11:54 am
- Forum: Winter 2011
- Topic: SQL queries on the vislab2 db
- Replies: 3
- Views: 6779
SQL queries on the vislab2 db
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 ...
- Tue Jan 18, 2011 10:24 am
- Forum: Winter 2011
- Topic: PROJET 1 FREQUENCY MAPPING: SUBMIT HERE
- Replies: 11
- Views: 16419